How to Import MS Access (.mdb) to SQL Database

Earlier in How to Export SQL Server Table to Access Database post we learned how to export SQL Server table to Access Database using SQL Server Management Studio Graphical User Interface.

Now in this article, we will learn how to import table from MS Access database to SQL database using SQL Server Management Studio Graphical User Interface.

Step-I: Open SQL Server Management Studio and click on Connect button as shown in the following Image.

Step-II:

Right-click on the database where you want to import table data. In this demo, we will use SampleDB database.
Move cursor to Tasks.
Click on Import Data… from the pop-up menu.

Step-III:

SQL Server Import and Export Wizard will open. Click on Next button.

Step-IV:

Select Microsoft Access (Microsoft Jet Database Engine) from the Data source drop down menu.
Browse the database file by clicking on Browse… button.
Click on Next button.

Step-V:

Select the SQL Server Native Client 11.0 from the Destination drop down menu.
Select Server name.
Select database from the drop down menu.
Click on Next button.

Step-VI:

Select Copy data from one or more tables or views if you want to import table or view completely. OR
Select Write a query to specify the data to transfer (You can import whole table data or filter the data using WHERE clause in the query).

Click on Next button.

Step-VII:

Select the table which you want to import from Select Source Tables and Views window.
Click on Next button.

Step-VIII:

Check the Run immediately check box if you want to run it without saving the SSIS Package. You can also save the SSIS Package by putting the check mark on Save SSIS Package check box.
Click on Next button.