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

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

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.

Can anybody help me out in this situation

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