Preview Data Dialog Box (SQL Server Import and Export Wizard)

 

Updated: January 11, 2017

After you specify the data that you want to copy, you can optionally click Preview to open the Preview Data dialog box. On this page, you can preview up to 200 rows of sample data from your data source. This confirms that the wizard is going to copy the data that you want to copy.

The following screen shot shows the Preview Data dialog box of the Wizard.

Preview data page of the Import and Export Wizard

Source
Displays the query that the wizard is using to load data from the data source.

Sample data grid
Displays up to 200 rows of sample data that the query returns from the data source.

After you preview the data, you may want to change the options that you selected on previous pages of the wizard. To make these changes, click OK to return to the Select Source Tables and Views page, and then click Back to return to previous pages where you can change your selections.

After you preview the data that you're going to copy and click OK, the Preview Data dialog box returns you to the Select Source Tables and Views page or the Configure Flat File Destination page. For more info, see Select Source Tables and Views or Configure Flat File Destination.

Get started with this simple example of the Import and Export Wizard

Community Additions

ADD
Show: