- Open Data Source Explorer, right-click the table name and select .
- Select External File as the Destination Type and click Launch.
- Click Browse and specify and Output File.
- Select a File Type from the drop-down menu.
- [Optional] Select the Column Labels in First Row check box to specify to use the first row of data as the column labels for the new table.
- If you selected Delimited Text as the file type:
Field Description Column Delimiter Type of delimiter to use in the output file using the list. The options are: - Comma
- Semicolon
- Space
- Tab
- | (vertical bar)
Character String Delimiter Distinguishes a string text. The options are: - " (double-quotes)
- ' (single quote)
- None
File Encoding Character set used to encode the data. The options are: - UTF-8
- utf-16
- ISO-8859-1
- UTF-16BE
- UTF-16LE
- US-ASCB
- Cp1252
If you selected Excel (.xlsx) or Excel 97-2003 (.xls), there are no additional options to complete.
- Click Next then indicate how to filter data for each column to be exported:
Option Action Filter by a column Check the box beside the column name Filter by data For each table column select a filter value from the Select By list and type the paired value. For example, the filter "> 200"" includes only those values greater than the numeric value 200. - [Optional] Click Next to preview the generated SQL.
- Click Finish.