Another way to copy SQL Server table Excel data

One, SQL Server table data is copied to Excel

1, new query, with SQL statements to read out the table data

2. Then, select data, right-click. Copy (also can click to copy with title), copy to Notepad (otherwise garbled)

3, then copy the contents of the Notepad, paste in Excel can be.

Second, Excel copy to SQL Server table data

1. Open Excel to copy data.

2. Open the SQL table in edit state

3. Right click on the left side of the table, select Paste (note that Excel columns must correspond to the columns of the SQL table)

4, assuming increment, do not copy auto increment field

Copyright notice: This article blog original article. Blogs, without consent, may not be reproduced.

Another way to copy SQL Server table Excel data