17

I can not find a solution for this error:

The 32-bit OLE DB provider "Microsoft.ACE.OLEDB.12.0" cannot be loaded in-process on a 64-bit SQL Server.

I found a lot of posts on the web but none work.

I am working with SQL server 2014 64 bits and office 2013

Code that generates the error:

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
                         'Excel 12.0 Xml;HDR=YES;Database=C:\SSIS\Table_nm.xlsx', 
                         'SELECT * FROM [Table_nm$]');
crthompson
  • 15,653
  • 6
  • 58
  • 80
Pablo Gûereca
  • 725
  • 1
  • 9
  • 23
  • 1
    Could you post the code that generates this error? – crthompson Apr 10 '15 at 17:46
  • sure this is the code: SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0 Xml;HDR=YES;Database=C:\SSIS\Table_nm.xlsx', 'SELECT * FROM [Table_nm$]'); – Pablo Gûereca Apr 10 '15 at 20:04
  • 1
    Have you tried using the 64 bit driver [here](http://www.microsoft.com/en-us/download/details.aspx?id=13255)? There are [several references](https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=microsoft.ace.oledb%2064%20bit) to it fixing similar problems. – crthompson Apr 10 '15 at 20:11
  • thanks paqo gomez, Gracias paco eso corrigio el problema, – Pablo Gûereca Apr 10 '15 at 21:39
  • Excellente, un placer. – crthompson Apr 13 '15 at 17:22

1 Answers1

32

As it turns out, you can get the 64-bit driver from here.

https://www.microsoft.com/en-us/download/details.aspx?id=13255

After you download it, don't double-click it to install it, install it using the command prompt, which should be something like this:

"C:\Users\rshuell001\Downloads\AccessDatabaseEngine_x64.exe" /passive

The '/passive' is the key here because it prevents the installation from failing if you already have the 32-bit version installed (via 32-bit Office).

Jonathan Leffler
  • 730,956
  • 141
  • 904
  • 1,278
ASH
  • 20,759
  • 19
  • 87
  • 200
  • Do you know why installation of 64bit driver (with or w/o /passive key) would fail? The error message states just that. Running as admin or regular user, no difference. – ajeh Jun 06 '16 at 17:06
  • In my case, just the "/passive" parameter was still causing an error, but I was able to make it work with AccessDatabaseEngine_x64.exe /quiet /passive – 8kb Aug 29 '22 at 18:50