I have an excel spreadsheet that I need to query from t-sql. To do this I am using:
'Excel 12.0 Xml;
'SELECT * FROM [Database$]');
This works fine, however, when that spreadsheet is open for use, I get the following error:
Msg 7399, Level 16, State 1, Line 3
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 3
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".
Is there any way to stil query this excel spreadsheet when it is open and in use?