Import Microsoft Access 2007 Database Tables into SQL Server 2008

Import Microsoft access 2007 database to SQL Server,Import Microsoft access 2007 database to SQL Server 2008,Import Microsoft access database to SQL Server,Import access 2007 database to SQL Server,Import access 2007 database to SQL Server 2008,Import Ms access 2007 database to SQL Server,Import Ms access database to SQL Server,Import Ms access 2007 database to SQL Server 2008,
Import MS access database, Import MS access 2007 database to SQL, SQL, Microsoft Access 2007,Import access 2007,Import MS access 2007,Import Microsoft access 2007 database tables to SQL Server,Import Microsoft access 2007 database tables to SQL Server 2008,Import Microsoft access database tables to SQL Server,Import access 2007 database tables to SQL Server,Import access 2007 database tables to SQL Server 2008,Import Ms access 2007 database tables to SQL Server,Import Ms access database tables to SQL Server,Import Ms access 2007 database tables to SQL Server 2008,
Import MS access database tables, Import MS access 2007 database tables to SQL, SQL, Microsoft Access 2007,Import access 2007 tables,Import MS access 2007 tables,

This article explains how to import Access 2007 database tables into MS SQL Server 2008.

To import data from a Microsoft Access 2007 database, we must install the OLEDB Provider for Microsoft Office 12.0 Access Database Engine.

1) Goto SQL Server Management Studio, Object Explorer

Right Click the desired database and select Tasks -> Import Data.

Follow the below steps to import data into a SQL Server 2008 database.




2)Select the Data source from which you want to import the data.
Because of the difference between the database engine of Microsoft Access 2007 and earlier version of Microsoft Access, it is not possible to connect to the Access 2007 database using data source “Microsoft Access”. You can use this if you wish to import data from a MDB format, but not an ACCDB from Access 2007.


If you have properly installed the 2007 Office System driver, you will see another Data Source option: “Microsoft Office 12.0 Access Database Engine.”

Step2: Select Microsoft Office 12.0 Access Database Engine

3) Click the Properties button to open the Data Link Properties window:

Step 3: Enter access 2007 database Path

Enter the full path of the Access 2007 database in Data Source Name. Click Test Connection to make sure the connection succeeds.


4) Click Ok to close the properties page. Click Next to choose the destination database

step4: Choose destination database

5. Click Next to continue.

Step 5: Select option to copy

choose option for Copy data from one or more tables or views.


6) Click Next, and select the Source Tables or Views to import. If necessary use the Edit Mapping button to map the Columns correctly.

Step 6: Select tables/view to copy

7) Click Next to continue.

 The next screen of the wizard shows two options.
 First one is to Execute Package Immediately and second one is to save SSIS package which can be used in the Business Intelligence Development Studio Project.

8) Click Next and Finish.

It shows the progress of copying data and lists out errors if any.

On successful import, you can expand the tables on the database and see the imported tables from Access database.