Introduction
In this article, I am going to explain to you how to import Excel sheet data to SQL server database table with examples. Here we will be using SQL Server 2019 or you can use SQL Server 2008 or above. In my current project, I am using this concept for data migration.
This concept is used for transferring data from source (Excel sheet) to destination (SQL Server). We can import a bulk amount of excel data into SQL database without using any coding.
There are two ways to import data from excel to SQL Server database. First, if you want to import all excel file data with header names in a new table. Secondly, if you want to append excel data in exiting table data without header names.
Prerequisites
SQL Server 2019 or you can use SQL server 2008 or above version.
Read my previous articles, using the below links,
- How To Install SQL Server 2019
- How To Install SQL Server Management Studio 2019
- Getting Started With SQL Server 2019
Import All Excel Data With Header Names In a New Table
Step 1
Here, I have created a sample Excel data that contains employees detail data with six columns.
Step 2
Connect To SQL Server Management Studio 2019 (SSMS) and create a database
Open your SQL Server and use the following script to create the “chittadb” Database.
Create database chittadb
Now, select the script query then press F5 or click on Execute button to execute the above script.
You should see a message, “Command(s) completed successfully.” Means your new database is created.
Database “Chittadb” created.
Step 3
Expand the database where you want to import the data. Here I want to import the data to “Chittadb” database. The database has no table now.
Right click your destination database ->Select Tasks -> Import Data
Step 4
An Import wizard pop up will open "Welcome to SQL Server Import and Export Wizard” and Click Next.
Join the conversation! Your thoughts help the community grow.