Export Flat File (Tables Menu)

DBExplorer can export data to a flat file. Upon selection of this function, a form is displayed and the export specifications may be defined.

Export Dialog Items

Export table

The name of the currently selected table that is to be exported.

Export file

The name of the destination file. A browse button is provided to allow file selection.

Columns

The name, type, starting position, length, and justification of the columns to be exported. Columns may be excluded by clearing the check box on the appropriate line.

Progress

The progress section shows the record count and a progress bar. A stop button allows the export to be aborted.

When exporting from the Data or SQL tab, only the selected rows are output. Use Select All before exporting to choose all rows of data shown. The Export Data function when other DBExplorer tabs are selected exports all rows in the selected table.