SQL Server Microsoft.ACE.OLEDB.15.0

Question

I am writing a query to access what is in Excel sheet (2013 - 32 bit) and display that as a table in SQL Server 2014 SP2 64 bit. And I get this error:

The OLE DB provider "Microsoft.ACE.OLEDB.15.0" has not been registered.

I have tried installing Access Runtime 2013 and 2010, but yet the same problem persists. The query am using is:

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.15.0', 
                         'Excel 15.0;HDR=YES;Database=C:\SheetName.xlsx', 
                         'SELECT * FROM [PayerList$]')

Answer 1

Microsoft.ACE.OLEDB.15.0 is the identifier of the OLEDB driver installed with the Access 2013 Runtime. It isn't installed with Excel. In fact, you don't even need Excel installed. You'll find the runtime here

Take care to download the correct runtime version. A 64-bit process can't use a 32-bit provider and vice versa. In your case, you should download the 64-bit version.

You should remove Excel from the server because it isn't used at all.