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 2nd 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.
