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 an example of SQL Server Import table data. Explain:
1. Open SQL Server Management Studio. In Object Explorer, expand the SQL Server instance → databases → databases for which you need to import data node. Right-click and select tasks → export data command.
The welcome interface for the Import and Export Wizard appears, click the Next button, and the Select Data Source dialog box appears,
2. Click "Next" button. The Select Data Source dialog box appears, setting such as the following options (as seen):
3. Click "Next" button, the "Select Target" dialog box appears, setting for example the following options (see):
4. Click "Next" button. The Specify Table copy or Query dialog box appears, as you can see:
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, for example:
Complete
SQL Server import also has table data in a database