SSIS : The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine(64 bit) even after installing "AccessDatabaseEngine_x64.exe"
Hello, I want to use "Microsoft Office 12.0 Access Database Engine OLE DB provider" under SSIS connection manager to get data from Excel 2007 files on a server with 64 bit. To facilitate this , Installed the “AccessDatabaseEngine_x64.exe” from http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255. After the installation , in the installed programs I can see that " Microsoft Access 2010 Database engine" has been installed. Also, I check the registry for confirmation. Under HKEY_LOCAL_MACHINE->SOFTWARE->MICROSOFT->OFFICE->14.0 But when I open SQL Server BI Studio on the server , under SSIS connection manager right click -> New OLEDB Connection. I am not able to see the "Microsoft Office 12.0 Access Database Engine OLE DB provider" which practically should be seen once we install the "AccessDatabaseEngine_x64.exe”. Note: The 64 bit server does not have the Microsoft Office installed" on it. Any help would greatly appreciated. Best, Aniket
July 21st, 2011 3:23pm

That is correct. BIDS (Visual Studio) is a 32-bit application, and as such, can't see ANY 64-bit provider, including the Office ones you just installed. In order to get a 64-bit connection to an Office provider working, you'll have to develop your package on a system with the 32-bit drivers installed, then deploy that package to a system with the 64-bit drivers installed. It's not pretty. There are a couple pitfalls along the way. I've covered some of them, but there's another post out there with your specific situation described... I just can't find it. Talk to me now on
Free Windows Admin Tool Kit Click here and download it now
July 21st, 2011 3:30pm

Thanks for the reply but I am able to see the 64 bit driver on my local machine(32bit) having BIDS which is 32 bit. I first created the SSIS package on my local machine which is 32-bit. When I open the SQL Server BI Studio on my machine, under connection manager I am able to see the driver.I created and ran the package successfully on my machine. But when I deploy the package to run as a job on the server it fails as it gives me "Class not registered" error. The only difference is I have Microsoft Office 2007 installed on my local machine.
July 21st, 2011 3:43pm

Can anybody help me out in this situation
Free Windows Admin Tool Kit Click here and download it now
July 21st, 2011 6:35pm

Please read the article I linked to. It has plenty of information to help you out, this is a common issue when using Office providers. Talk to me now on
July 21st, 2011 8:01pm

Hello, Finally I figured out a way. On a 64 bit server having SQL Server 2008 (64 bit). Install the "AccessDatabaseEngine.exe"(32 bit) file from the link http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255. This link has 64 bit exe file also. Do not install the 64 bit one Install the 32 bit one. As BI Studio is 32 bit. It can see the drivers when u make a connection in SSIS. After that when executing that SSIS package as a job step. Go to Execution options and check mark the 32 bit option. Thanks!!
Free Windows Admin Tool Kit Click here and download it now
May 4th, 2012 5:23pm

Hello, I'm facing same issue. But I've MS Office with 64 bit. OS: Windows Server 2008 R2 Enterprise Office: MS Office 2010 64 bit. - I'm not able to get the provide "Microsoft Office 12.0 Access Database Engine OLE DB provider" even after installing "AccessDatabaseEngine.exe" 64 bit in SSIS package. When I'm trying to install "AccessDatabaseEngine.exe" 32 bit it not allows me. But I can able to install 64 bit AccessDatabaseEngine perfectly. Please let me know what I need to do.
October 9th, 2012 11:06am

You need to develop on a machine with the 32-bit version of Office :( Or you can put some trust in myself who was passed along an installer for the Access Database Engine with the "check" for the 64-bit version of Office disabled. With this install, you should be able to have the 32-bit and 64-bit engines at the same time: https://skydrive.live.com/redir?resid=C76C3CBDB305921!2281&authkey=!AHZdz3DOfmVYuc0 Talk to me now on
Free Windows Admin Tool Kit Click here and download it now
October 11th, 2012 11:56am

You need to develop on a machine with the 32-bit version of Office :( Or you can put some trust in myself who was passed along an installer for the Access Database Engine with the "check" for the 64-bit version of Office disabled. With this install, you should be able to have the 32-bit and 64-bit engines at the same time: https://skydrive.live.com/redir?resid=C76C3CBDB305921!2281&authkey=!AHZdz3DOfmVYuc0 Talk to me now on
October 11th, 2012 11:56am

You are awesome Todd!!!! Thanks a bunch for that download, you don't understand how long I have been pulling my hair out try to get SSIS to work on a 64-bit machine. I wish Microsoft cared enough about supporting their crappy products as you do, you are awesome my friend.
Free Windows Admin Tool Kit Click here and download it now
November 6th, 2012 11:29am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics