IMPORT DATA FROM EXCEL FILE TO SQL SERVER DATABASE

Today we have a look how to Import Data from Excel to SQL Server Database. Please review below Steps.

Here is an excel file which list down some sample Records in Excel file.

 

Now we need to import these records in a Table or Database 

Select  the Database in which you need to import the Records.

 

 

A wizard open 

 

 

Select the Data Source  that is your Excel Sheet.

 

 Next Select your Destination here is this case we have SQL Server Database, the Sample Database

 

 

Click Next and the select Copying Query and then select Preview to view the excel Records.

 

 

 

Click Next and the Click Finish, All Records in the Excel file are now Copied imported to Database Table Name $Sheet1

 

 

You can see a Table is added to the Database

 

 

The Select Query on the table shows the Records.

 

 

 

Hope you have learn how to Import Data from Excel to SQL Server Database Table or tables.