Ways to import Excel data into SQL tables

1. Create Excel data table paired with database

2. Get the INSERT statement script in SQL to sort out the format of the Orange field

3. Each data field is converted to data in SQL format, such as: Blue section

4, and then the blue part of the data with a comma interval to join together

5, the orange part and the yellow part of the link to form a yellow part of the final INSERT statement

6. Copy and paste the yellow parts into the Query Analyzer and run the import successfully

7, if you want to delete the original input after the import needs to run the DELETE statement

This method is useful for importing data for the first time. As long as you write an INSERT statement for a record, other records can be easily obtained using Excel's copy function.

Excel uses a simple formula, you need an Excel document can be sent to the mail request. (This place can't upload files.) ）

Ways to import Excel data into SQL tables