You are currently viewing How to Import MS Access (.mdb) to SQL Database

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

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.

Open MSSQL

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.
Import Access Table to SQL Database 1

Step-III:

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

Step-IV:

  1. Select Microsoft Access (Microsoft Jet Database Engine) from the Data source drop down menu.
  2. Browse the database file by clicking on Browse… button.
  3. Click on Next button.
Import Access Table to SQL Database 2

Step-V:

  1. Select the SQL Server Native Client 11.0 from the Destination drop down menu.
  2. Select Server name.
  3. Select database from the drop down menu.
  4. Click on Next button.
Import Access Table to SQL Database 3

Step-VI:

  1. Select Copy data from one or more tables or views if you want to import table or view completely.  OR
  2. 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.
Export SQL Table to Access mdb 6

Step-VII:

  1. Select the table which you want to import from Select Source Tables and Views window.
  2. Click on Next button.
Import Access Table to SQL Database 5

Step-VIII:

  1. 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.
  2. Click on Next button.
Export SQL Table to Access mdb 10

Step-IX:

  1. Click on Finish button.
import file review

Step-X:

  1. The execution successfully completed.
  2. Total number of rows imported will be shown.
  3. Click the Close button.
Import Access Table to SQL Database 6

The table will be imported successfully which you can see in SQL Server Object Explorer.

Import Table From Access DB to SQL Server Table-7

Buy Best Stationery Products in Pakistan

Piano Ballpoint Pen

Piano Ballpoint Pen

ORO Trimetal Pencil

ORO Trimetal

Dollar Clipper Pen

UHU 10×7 ml Pack of 10 PCs

UHU 10×7 ml Pack of 10 PCs

Glue Stick 8g Pack Of 12 PCs

Glue Stick 8g

Color Pencils Box of 12 PCs

Deer Multi Color Pencils