Share via


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:

image

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.