Importing Excel data into the SQL server table

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

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

Now we will see how we will Import the excel data into the Sql server table.

Right Click on the databaseàTasksàExport Data  

Now we are selecting the data Source file  

Click on the next button.    

Selecting the destination server and database. If we are using the SQL Server Authentication we need to provide the user ID name and password.

Click Next 

If we have single or multiple sheets to load in this case we need to select first option. If we want to make any changes or we need to load specific data then we will select the 2^nd option.

Here we are going with option one.

Click next. 

Selecting the sheet name.

If we want to edit the mapping we can click on the Edit Mappings button.   

If we mark checked to Drop and re-create destination table in this case always it will drop the table and recreate it.

If we want to Enable Identity we need to make it checked.

If we want to make any changes in the data type we can do in this window.

 Click ok.

If we want to see the data in excel  Click on the preview button.

  

Click ok.

Now click the Next Button.   

Click next  

Click finish  

Data Imported into the table. See the table.

                               
In this way we can load the excel data into the database table very easily.