Replication of SQL Server table data to data in Excel

One, SQL Server table data copied to Excel

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

2, then, select the data, right-click, copy (also can be clicked together with the title copy), copied into Notepad (otherwise garbled)

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

II. 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 bottom row of the table to the left of the ordinal, select paste (Note that Excel column must correspond to the columns of the SQL table)

4, if there is self-increment, do not copy the self-increment field

Replication of SQL Server table data to data in Excel