hey
I am just trying a simple query of an Excel file.
Select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\MyFile.xls;HDR=YES', 'SELECT * FROM [Sheet1$]')
and i am getting this error
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.].
I know for a fact that the path is correct and that it is the path of the server. So what is the problem with this??
tibordoes someone have the spreadsheet open?|||nope not at all|||oh ok i found out the issue. i was using vb with excel and was terminating the debug program without closing out excel so i had several in memory still
No comments:
Post a Comment