I have a file in my C:\temp folder
File name is Test.xlsx
I'm trying to do an openquery on the file...see attached code
I installed the engine and I turned on the Ad Hoc Distributed queries with
sp_configure 'show advanced options', 1;
sp_configure 'Ad Hoc Distributed Queries', 1;
When I run my attached code I get this error message
Msg 7302, Level 16, State 1, Line 1
Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.12.0"
for linked server "(null)".
select * FROM OPENROWSET (
'Excel 12.0;Database=C:\temp\Test2.xlsx;HDR=YES' ,
'SELECT * FROM [Sheet1$]' )