Excel data import into SQL Server database

STEP1: Open the database and select the database where you want to import the target table

STEP2: Task---Import data

Step3: The data source selects Excel, selects the corresponding path, the version, and whether the first row is the header row.

STEP4: Select Target, this is the target is SQL Server, fill in the corresponding server database name.

STEP5: As needed, I'm going to import all the data in the table, so I'll choose the first one.

STEP6: Source and destination. If Excel has more than one table sheet, select the corresponding sheet. The goal is to create a new table by default. Here we are going to import the data into the existing table, so select the corresponding target table.

The Excel and Target table fields correspond before the import, so the mappings are not checked.

STEP7: Because you can confirm that this data is not a problem, select the problem handling mode select "Ignore".

STEP8: This selection runs immediately.

Step: See the results, success

Excel data import into SQL Server database