Tip: 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 -http://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. 

source: http://blogs.technet.com/b/vipulshah/archive/2011/06/07/importing-data-from-ms-access-2010-64-bit-accdb-database-into-sql-server-using-ssis.aspx