In this section you will know how to import Excel data in SQL server. This is the manual way to import Excel data in SQL server Database. However, you can use command as well to import data into Table. Using SQL Command Load data Text data into Table (Command will helpful to make procedure to import data. Fully automatic way)
Here, we are using “ProductInfo” database to import three data sample:
Steps: Import Excel Data in SQL Server
Step #1: Open Management studio and login with your credential. Then Select database > right click > Click “Tasks” > Import Data > (from Explore option)
Step #2:
- Next Wizard, Select Data Source as Excel > Browse Excel file > Select “Microsoft Excel 97-2003” >
- Select Check box “First Row has column Name”
- Click Next Button
Step #3:
- Next Wizard Select Destination as “Microsoft OLE DB Driver for SQL Server” >
- select radio button “Use Window Authentication” >
- Select Database (database where you want to import the excel data and want create table for that data)
- Click Next Button
Step #4: You will see all sheets which is available with data. you need to select those sheet, which you would like to import as table in selected database
- Select Order tab Clicked Next Button (If you want to change the Table name then Double clicked on name and change name)
- Then finally click on Next button
Step #5: By default “Run immediately” option checked marked. Click Next Button on Wizard
Step #6: It will cehck the all action list on Excel data and give the status as “Success”. Finally clicked on Close Button
Successfully! imported excel file in “Orders_Tbl”
See below pic, similar you can do for “Product Supply_Tbl” and “Customers_Tbl” data. the steps will be the same only need to give table name at step #4
now you can perform all data Manipulation command on these table using Management studio.