Hi,

For me this works

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=P:\Statements\Activity20100422.xls',['Trade Date Detail$'])

PetrPan

Remote computer means computer connected via internet to VPN. There is installed application on this "remote computer". This application is accessing (via SQLOLEDB provider) DB on MS SQL (enterprise or...

Grant Fritchey (3/15/2011)

---

... But, the biggest difference to me is that one database is local and the other is through a network. The local one is fast, the networked one...

toniupstny (11/14/2007)

---

When I tried an approach (just messing around) similar to the

col1=val1 and col2=val2....

when one of the cols had nulls then it doesn't equate to another null so...