Introduction
In this article you will learn how to Import Excel Data Into Microsoft
SQL Server. We can import bulk amounts of excel data into SQL database using the following steps without using any programming language.
Step 1: The following excel sheets have a small amount of informational Data.
Step 2 : Go to MS SQL Server and right click your database name -> Tasks -> Import Data,
Step 3 : It opens one wizard "Welcome to SQL Server Import and Export Wizard " so we can import excel into MSSql easily.Click Next in the Wizard.
Step 4 : Select Microsoft Excel as your data source and choose excel file location in your system after that we need to specify the version of the excel file and click Next.
Step 5 : The following screen shot shows the destination details of excel file and click Next.
Step 6 : This step will copy the data from the data source click next and continue.
Step 7 : We can specify the table name in the following wizard.So change the destination section name "[dbo].[Sheet1$]" as "[dbo].[ExceltoSql]" and click Next.
Step 8 : Click Finish.
Step 9 : The execution was successful.
Step 10 : The following Output contains Name and City as the column name.
Summary :
We learned how to Import Excel Data Into Microsoft SQL Server. I hope this article will be useful for beginners.
Read more articles on SQL Server: