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
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.
We will make sure that the data is imported.
