How to copy SQL Server tables and EXCEL Data in batches (solved)

How to copy SQL Server tables and EXCEL Data in batches (solved)

1. Copy SQL Server table data to excel (method)

1. Create a New query and read the table data using SQL statements.

2. Then, right-click the data and copy it (you can also click Copy together with the title)

3. paste it in excel.

Ii. Copying data from an excel file to an SQL Server table (method)

1. Open excel to copy data.

2. Open an SQL table in the editing status.

3. Right-click the serial number on the left of the row at the bottom of the table and choose paste. (Note that the excel column must correspond to the column in the SQL table)

4. If there is auto-increment, do not copy the auto-increment field.