Export Table Data to an External File | Teradata Studio/Studio Express - Exporting Table Data to an External File - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.00
Published
January 2021
Language
English (United States)
Last Update
2021-01-11
dita:mapPath
lex1576517377362.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
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.
  1. Select a table object in the Data Source Explorer to use as the source table for exporting data to a file.
  2. Right-click the selected table object and select Data > Export Data.
  3. In the Data Transfer Wizard, select External File (FastExport) as the Destination Type.
  4. Specify table data export settings:
    1. 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.
    2. Select a File Type.
    3. 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.
    4. Select a Column Delimiter from the drop-down menu.
    5. [Optional] Select a Character String Delimiter from the drop-down menu.
    6. [Optional] Select a File Encoding type from the drop-down menu.
  5. Click Finish.