I am trying to use Microsoft Office 12.0 Access Database Engine OLE DB provider to query an XLSX file with
OPENROWSET. An attempt to query just spins in SSMS without error, failure, or a result set.
I also tried using this driver to setup a linked server. It too did not fail, error or provide a result.
I can create an SSIS package and import successfully from the excel file using the import tool. From what I can tell, this uses the same driver that failed for the linked server and
I have set the following...
USE MASTER; GO EXEC SP_CONFIGURE 'SHOW ADVANCED OPTIONS', 1; RECONFIGURE; GO EXEC SP_CONFIGURE 'AD HOC DISTRIBUTED QUERIES', 1; RECONFIGURE; GO EXEC SP_MSSET_OLEDB_PROP N'MICROSOFT.ACE.OLEDB.15.0', N'ALLOWINPROCESS', 1; GO EXEC SP_MSSET_OLEDB_PROP N'MICROSOFT.ACE.OLEDB.15.0', N'DYNAMICPARAMETERS', 1; GO
What am I missing?