maverick0728
asked on
Cannot query open Excel file from SQL Server
I have an excel spreadsheet that I need to query from t-sql. To do this I am using:
This works fine, however, when that spreadsheet is open for use, I get the following error:
Is there any way to stil query this excel spreadsheet when it is open and in use?
SELECT *
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0 Xml;
Database=C:\user\test.xls',
'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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.