Exporting Table Data | Teradata Studio/Studio Express - Exporting Table Data - Teradata Studio

Teradata® Studio™ User Guide - 17.20

Product
Teradata Studio
Release Number
17.20
Published
September 2022
Language
English (United States)
Last Update
2022-09-23
dita:mapPath
gvw1648839236371.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
Product Category
Teradata Tools and Utilities

The Table Data Editor uses the Export Data wizard to export data from tables to a file, such as a Microsoft Excel spreadsheet or a text file. You can select data to export all data in the table or only data in specific rows to export.

Exporting All Data

The Export All feature exports all data in the table.

  1. Click "" .
  2. Follow the steps for Export Data wizard.

Exporting Data in Rows

The Export feature exports only data in the table rows you select.

  1. Select the data rows you want to export.

    You can select multiple rows using the Ctrl key.

  2. Right-click and select Select Rows for Export.

    The rows are marked "" for export.

  3. Right-click and select Export Selected Rows.
  4. Follow steps for the Export Data wizard.

Exporting with Teradata Export Wizard

  1. The Export Data dialog box opens. Follow these steps for both Export All and Export tasks.
  2. In Output File, click Browse to specify the path name of the file to which you want the data exported.
  3. In File Type, select from the list the type of the output file in the previous step. For example, you can select a delimited text file, Excel, or Excel (97-2003) file.
  4. Select Column Labels in First Row to specify that you want column labels to be output in the first row of the file.
  5. Under File Options, if you selected a delimited text file as the output:
    1. In Column Delimiter, select the column delimiter to be used in the output file to separate columns.
    2. In Character String Delimiter, select the character string delimiter to be used in the output file to indicate character strings.
  6. In File Encoding, select the encoding standard to use.
  7. Click Finish to export the data.