Importing Data from MS Access 2010 64-bit .accdb database into SQL Server using SSIS
Problem:
You can’t connect using Native OLEDB \Microsoft Jet 4.0 OLEDB Provider. It fails with following error message:
Test connection failed because of an error in initializing provider. Unrecognized database format 'C:\Users\vishah\Documents\myDB.accdb'.
Solution:
- Download 2007 Office System Driver: Data Connectivity Components from here - https://www.microsoft.com/downloads/en/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en
- then choose Microsoft Office 12.0 Access Database Engine OLE DB Provider and point it to your .accdb file.
Comments
Anonymous
August 22, 2012
He Vipul thankx for your post , for last 2 days I am trying to connect and i got the same error as you postAnonymous
August 22, 2012
I downladed and instal the engine but still i am getting the same issueAnonymous
May 09, 2013
The comment has been removedAnonymous
November 26, 2013
After downloading and installing, I am not seeing "Microsoft Office 12.0 Access Database Engine OLE DB Provider" appear as an option to select in the import wizard. However, I am using SQL server 2012. This does seem to work and the option appears on an instance of SQL server 2008 r2 though. Any ideas on how to get the "Microsoft Office 12.0 Access Database Engine OLE DB Provider" option to appear on Sql server 2012?Anonymous
December 05, 2013
Your looking into 32-bit version of import/export wizard. Try looking in the 64-bit version of the wizardAnonymous
September 18, 2015
even using the 64 bit version it's still not there.