Importing MS Access data into the SQL server table

 In previous the post, we saw how to import SQL server table data into the Access Database.

Read here: ImportingSQL Server table data to the MS Access

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

Now we will see how we will Import the MS Access data into the SQL server table.

Right Click on the databaseàTasksàExport Data

  

Now we are selecting the data Source file  

Click next and select the destination database when we are going to import.  

Selecting the next  

Selecting option on and clicking on the next.  

If we want to edit the mapping click on the Edit Mapping Button.  

Click ok.

Here we are reviewing the data.

                                     

Click next. 

Click next.

Click Finish

Table created and data transferred successfully.

See the data into the SQL server database.  

Thanks.