Data from table structures and tables is supported only from SqlServer2008, andSqlServer2008 The previous database only supports the export table structure, sometimes we may need to export 2008 of the data from the previous database, this time we can use a compromise method, first export the database to Excel, And then import the data in Excel into the database (if the two database servers can be interoperable, you can directly establish a remote link for data transmission, not so troublesome),It 's easier to export data from SQL Server to Excel, no more stickers here, here'sTo import data from Excel into SQL Server step:1.
2.
3.
4.
5.
6.
7. Then click on the ' Edit Map ' button
8.
9. Click Finish or continue to click Next to finish. Wish: Smooth
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
Data in Excel is imported into the SQL Server database