To export a table to a text file

  1. Open the Data Transfer Tool.

  2. Select Export Text File from the main console or the Transfer menu. The Welcome to Import from Text File Wizard window will open, displaying a summary of the steps to be taken in the wizard.

  3. Click Next. The Choose a Data Source window will open.

  4. Select the database to export data from in the Database menu.

  5. Enter a user name and password into the appropriate fields.

    Note: A user must have SELECT privilege to export a text file.

  6. After you have selected a database, click Next, the Table or Query Export window will open.

  7. Select Table to export data from a table. Select SQL query to export data from the result set of an SQL SELECT statement.

  8. If you selected Table from the Table or Query Export window, the Table Export window will open. If you selected SQL query, then proceed to step 13.

  9. Click Next, the Table Export window will open.

  10. Select a table to export from the Table name menu. A list of columns in the table will appear in the Select columns to export field.

  11. Select columns by clicking on the column name and clicking Add, or select all columns by clicking Add All. Selected column names will appear in the right hand field.

  12. Click Next. The Name The Text File window will appear (proceed to step 16).

  13. If you selected SQL query from the Table or Query Export window, the Query Export window will open.

  14. Enter a valid SQL select statement into the SQL query field.

  15. Click Next. The Name The Text File window will appear.

  16. Enter the full path of a text file in the Text file field, or select one using the browse button.

  17. Click Next. The Text File Format Setting 1 window will open.

  18. Select the appropriate settings for the format of the text file you will create.

  19. Click Next. The Text File Format Setting 2 window will open.

  20. Finish selecting the appropriate settings for the format of the text file you are creating. Click Execute to export the data to the text file. A confirmation dialog box will appear.

  21. Click OK


Related topic:

Exporting Data to Text