Categories
Sql Server

How to Export Excel data in SQL Server table

How to Export Excel data in SQL Server table

Many Sql server guys deal with this How to Export Excel data in SQL Server table.Many DBA following the same approach they export data from flat file or other type of file to SQL server tables.Here we have a quick view on how to export data from excel file to SQL Server table.

Images below give you full discription for it:-

  1. Choose your Excel file from where to export data.
  2. Open SQL Server Management studio.
  3. Follow instruction as in Images below.

(Click on image to enlarge)