0

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 OPENROWSET.

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?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.