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.