SQL Server2016 exporting data table data

SQL Server2016 exporting data table data Gao Wenrong 0 People reviews3914 people read 2017-09-22 08:41:56

SQL Server2016 exporting data table data

We've already covered a lot of relevant articles on SQL Server, and today we're going to show you how to export the data in the table below.

All of our operations are done through SSMS.

We right-click the database that needs to export the data----task----export the data

Following the wizard prompts, the next step

Select a data source---Select SQL Sever Native Client xx

Then select the database

Data data source and database and verification information

Target use: Microsoft Excel

We select the highest version of the Excel version

Confirmation information

Because we have only one table under our database, so let's go straight to the next

Confirmation information

Execute now

Export complete

We view the exported data

In addition, we can also operate in the following ways;

The disadvantage is that if the database under the table more words can not be exported once, if only to export a single table, the following methods,

In fact, it is recommended to use the first method for data export;

We need a query that executes the table data through the statement, and then right-click the query's data---Select All

Then the select all data----Save the results as

Save Type

Copyright belongs to the author: from 51CTO blog author Gao Wenrong original works, declined reprint, otherwise will be held liable

SQL Server2016 exporting data table data