We can do this by many ways with SQL SERVER.
1. We can use SSIS package
2. Import/Export Wizard
Today, I am going to explain, How to import data from Excel file by TSQL.
To import Excel file by TSQL, we need to do following:
1. Put Excel file on server, means we need to put files on server, if we are accessing it from local.
2. Write following TSQL, to read data from excel file
NOTE: Here, Excel file is on "C:\" named "SQLYoga.xls", and I am reading sheet "SQL" from this excel file
If you want to insert excel data into table,
Posted by Tejas Shah on November 22, 2017
Posted by Tejas Shah on November 11, 2017
Posted by Tejas Shah on August 12, 2015
Posted by Tejas Shah on June 26, 2015
Posted by Tejas Shah on April 20, 2015