Search code examples
sql-serverssisoffice-interop

Import ACCDB file of Access DB into Sql Server 2014

I am trying to follow this.I have successfully installed 2007 Office System Driver: Data Connectivity Components. However, I just cannot see the choice: "Microsoft Office 12.0 Access Database Engine" in SSMS during the import (restarted computer as well). I just cannot see what I may have missed. Any ideas? Btw, I am running Windows 7.

Solution

  • Probably too late to help you, but in case it helps anyone else, the work-around/solution that worked for me was to use the .Net Framework Data Provider for ODBC (with the 32-bit DTSWizard). For setting the data source properties, the simplest thing is to type in the following:

    Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=<path to mdb/accdb file> -- then you don't have to mess with setting up an ODBC DSN.