select * from openquery(LINKEXCEL_OL, 'select * from [Sheet1$]')
Everything is ok until the select when I get this very descriptive error(sarcasm):
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.].
Does anyone have any suggestions??? I am very lost and do nto see why this wouldn't work..