Extracting Table Data

You can extract a table's data to an external file.

You can select any row and column in the Table Data Editor, as well as set the XML header, column delimiter, and the encoding of data.

  1. Open a table in the Table Data Editor.
  2. Right-click the table and select Extract Table Data.
  3. Select a project folder.

    You can click Create Project to create a new project.

  4. Enter a File Name.
  5. In the File Type field, select a file format.
    Option Description
    Plain text (*.txt) Creates a text file containing the data.
    XML (*.xml) Creates an XML file containing the data.
    HTML (*.html) Creates an HTML file containing the data.
    CSV File (*.csv) Creates a CSV file containing the data.
    SQL (*.sql) Generates insert SQL statements and creates a SQL file.
  6. (Optional) Select a default Output Encoding other than the default encoding for the current locale:
    • Cp1252
    • ISO-8859-1
    • US-ASCII
    • UTF-16
    • UTF-16BE
    • UTF-16LE
    • UTF-8
  7. Select the Output Format for .txt file types:
    Option Description
    Column-Aligned Uses a same-width font to display the result, align each column, and fill spaces between columns.
    Comma-Separated Uses commas to separate columns.
    Tab-Delimited Uses tabs to separate columns.
    User-Defined Uses a user-defined string to separate columns.
  8. Click OK.

    A new file is created and opened in the default editor.

Related concepts
Table Data Editor
Related tasks
Editing Table Data
Filtering Table Data
Truncating Table Data

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com