You can select a database table and export the data in the table to a TXT, CSV, XSL, or XSLX file in your file system.
- Select a table object in the Data Source Explorer to use as the source table for exporting data to a file.
- Right-click the selected table object and select .
- In the Data Transfer Wizard, select External File (FastExport) as the Destination Type.
- Specify table data export settings:
- In Output File, specify the name of the file to receive the data and the server path to its location in the file system. To locate an existing file, click Browse and navigate the file system to select a file.
- Select a File Type.
- Check the Select Column Labels in First Row check box to retrieve the column headers in the table to be written as the column labels in the first row of data in the export file.
- Select a Column Delimiter from the drop-down menu.
- [Optional] Select a Character String Delimiter from the drop-down menu.
- [Optional] Select a File Encoding type from the drop-down menu.
- Click Finish.