How to bulk import massive data from excel to sql server database

Question

I've created a database that includes about 60 tables and I did the required relationships in between.

All tables are empty now. All tables should be filled in with data from Excel workbooks.

How to do the bulk import form data from excel to SQL database?

Thanks

Answer 1

The simple way to import data from an Excel file to a specific SQL table in the SQL Server database is using Import Wizard

Import data from Excel to a table in SQL Server

1. Right-click on the database that contains your tables and clicks on > Tasks > Import Data.
   

2. Select Data source as Microsoft Excel and specify the path of the Excel file.
   

3. Choose the Destination as SQL Server then select the database.
   

4. Click Next to specify the table copy or query
   

5. Select the source table from Excel and destination table from your database and click next
   

6. Click next to the next step
   

7. This step make sure you are select the checkbox of run immediately and click next
   

8. Click Finish to finish the wizard and wait until the wizard completed successfully.
   

Note: Make sure the Excel sheet has the same structure as the SQL table in the database.

---

See Also

• Check other options at Import data from Excel to SQL Server or Azure SQL Database
• How to copy a table with design and data from one database to another database?

Comments

Thanks a lot.
Please, if I am importing data several times on a daily basis, so I've to repeat these steps each time?
Or there is a simpler way to do so?
The reason for asking is that I've about 130 workbooks that are generated and must be added to the database daily and each table from excel is going to be added to an exact table in the database as you just thankfully showed me.
The Excel workbooks will always have the same exact format.
Thanks