Excel Import to SQL Server Database via SSMS

Last modified date:

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.

My name is Jan Zedníček and I work as a BI Developer at Kentico Software in Brno. Mostly you can see me there working in the office, but I also work partly as a freelancer. I have been working as a freelancer for many companies for more than 5 years, but Kentico is the matter of my heart. I used to work as a financial controller at companies like Aero Vodochody or Sberbank and I also used to be a bond program manager in Unicapital Investment group. 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 (because of the rum effect, you know =) and to put them forward to anyone. Don´t worry about asking for help or writing some comments.

Category: Excel tutorials SQL Server

About Ing. Jan Zedníček - BI Developer, Finance controller

My name is Jan Zedníček and I work as a BI Developer at Kentico Software in Brno. Mostly you can see me there working in the office, but I also work partly as a freelancer. I have been working as a freelancer for many companies for more than 5 years, but Kentico is the matter of my heart. I used to work as a financial controller at companies like Aero Vodochody or Sberbank and I also used to be a bond program manager in Unicapital Investment group. 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 (because of the rum effect, you know =) and to put them forward to anyone. Don´t worry about asking for help or writing some comments.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.