I tried to use OpenDataSource to query excel spreadsheet:
SELECT *
FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="e:\billings\template.xls";Extended properties=Excel 8.0')...[Sheet1$]
The query runs okay on the local server but fails when I exec it on my PC. I've got the following error message:
Server: Msg 7399, Level 16, State 1, Line 1
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.].
Any Ideas?
Many Thanks!
yl