SQL Server Imports table data from another database

When it comes to SQL Server programming or management, you will use the import and export of data, there are many ways to import and export, here is the SQL Server Import table data as an example, explain:

1. Open SQL Server Management Studio, in Object Explorer, expand the SQL Server instance → database → database to import data node, right-click and select tasks → export data command. " The Welcome screen of the Import and Export Wizard appears, click the Next button, and the Select Data Source dialog box appears,

2. Click the Next button and the Select Data Source dialog box appears, setting the following options ():

3. Click the "Next" button, the "Select Target" dialog box appears, set the following options ():

4. Click the Next button and the Specify Table copy or Query dialog box appears:

5. Here is an example of "copying data from one or more database tables or views":

6. Select the table you need to click Next, such as:

Complete

Copyright: jiankunking Source: http://blog.csdn.net/jiankunking This article is copyright to the author and Csdn, Welcome to reprint, but without the consent of the author must retain this paragraph, and in the article page obvious location to the original connection.

SQL Server Imports table data from another database