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

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.