Importing SQL server table data to the MS Access

 In the previous post, we seen how to Importing SQL Server table data into the excel.

 Read Here: Importing SQL server table data to the Excel

https://bageshkumarbagi-msbi.blogspot.com/2021/03/importing-sql-server-table-data-to-excel.html

 In this post Let’s see how to Importing the Sql Server table data to the Access DB.

Right-click on the database àselect tasksà Export Data

  

Select the server name and the database name

  

If we are using the SQL Server Authentication we need to provide the user name and password.

Click on the next   

Selecting the Destination as Microsoft Access and providing the File name where we are going to store the data.

In the advance table, we can set the initial catalog.

After that we can click on the test connection. If everything is good then we will get the message like Test Connection Succeeded else we get an error.

Click next 

If we want to export more than one table or whole table data in this case we will select option one. If we want to select specific data then we need to write the SQL script to pull the data, in this case, we will select the 2^nd option.  

Here we are selecting the table name which we want to export.  

If we want to make any change in the data type or table structure in this case we can click on the Edit Mapping button.  After making changes click on the Ok button.

Click the next button and review the source and destination.

  

Click next 

Click next. 

Click finish  

Data copied successfully.

Now close the wizard.

 See the MS Access database.   

Data copied successfully.