Import of Excel sheet or csv file into SQL Server is a quite common task. You can find a guide on how to do it below. Let’s have an excel file containing data on companies:

[1] Source Data
[2] Destination – database “test_databaze”
 

 

 

 

 

 

 

 

 

Steplist – Import Excel to SQL Database Example

1) Data import to the database is done via simple interface named SQL Server Import and export wizard. It can be accessed by right mouse button click above database – Tasks – Import Data

SQL Server Import and Export wizard

2) Select Microsoft Excel source as a data source and set a path to the file. Click on Next afterwards.

3) Select SQL Server Native Client 11.0 as a destination and set parameters Server and Database

4) You can definitely go through next steps on your own. Select pages of Excel that you need to get imported and just hit the confirm button. The data will get copied on the end of the wizard.

Import Excelu do SQL databáze

We will make sure that the data is imported.

Rate this post

Jan Zedníček - Data & Finance

My name is Jan Zedníček and I work as a freelancer. I have been working as a freelancer for many companies for more than 10 years.
I used to work as a financial controller, analyst and manager at many different companies in field of banking and manufacturing. When I am not at work, I like playing volleyball, chess, doing a workout in the gym and I enjoy tasting of best quality rums.
I am trying to summarize all my knowledge on this website not to forget them and to put them forward to anyone.

Leave a Reply

Your email address will not be published. Required fields are marked *