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 post

• Anonymous
  August 22, 2012
  I downladed and instal the engine but still i am getting the same issue

• Anonymous
  May 09, 2013
  The comment has been removed

• Anonymous
  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 wizard

• Anonymous
  September 18, 2015
  even using the 64 bit version it's still not there.