SQL Server imports table data from another database.

SQL Server imports table data from another database.

Data import and export are required when SQL Server programming or management is involved. There are many ways to import and export data. Here we take SQL Server as an example to describe how to import table data:

1. Open SQL Server Management Studio, expand the "SQL Server instance"> "Database"> "database to which you want to import data" node in the object resource manager, and right-click the node, select "task"> "export data" command. The welcome page of the Import and Export wizard appears. Click "Next" to display the "Select data source" dialog box,

2. Click "Next". In the "Select data source" dialog box, set the following options ():

3. Click "Next". In the "select target" dialog box, set the following options ():

4. Click "Next". The "specify table copy or query" dialog box is displayed ,:

5. Here we use [copying data from one or more database tables or views] as an example:

6. Select the expected table and click Next, for example:

Complete

Copyright Disclaimer: Author: jiankunking Source: http://blog.csdn.net/jiankunking this article copyright to the author and CSDN a total, welcome to reprint, but without the author's consent must retain this statement, and in the Article Page clearly given the original connection.