Data Export

Previous  Index  Next  How To Use

Database Workbench offers two wizard for easy exporting of data to different file formats, different editions support different export formats.

 

The Export Data Wizard - Tools | Export Table or View - offers you export from a single table or view - the Multi Export Data Wizard - Tools | Export Multiple Tables or Views - offers exporting a selection of tables and/or views. Alternatively, the context menu on a table, view, list of tables or views in the Database Navigator lists these options as well.

 

Currently, the following formats are available:

 

Extension

Description

sql

SQL INSERT INTO statements

dwx

Database Workbench Export - multi table export format

dbf

dBase File

txt

Padded Text File

xls

Microsoft Excel® File

csv

Comma Separated Values File

wk?

Lotus 1-2-3 File

dif

Data Interchange Format

xml

XML File

 

Both wizards are pretty much the same, except that the Export Data Wizard allows you to select the fields to export (see screenshot).

 

Export Data Wizard - after selecting a table and target, select the columns to export

 

Export Data Wizard

When using the single export wizard, you can select the fields from your table/view after selecting one.

 

Several export formats are supported - also SQL INSERT statements so you can easily populate a table in another database or save the records for later. When using this format, you need to enter the table name that the INSERT statement is supposed to insert in. BLOB columns will not be saved.

 

Multiple Export Data Wizard

When using this wizard, you cannot select the fields for a table/view, all fields will be exported. Saving files will be done to a folder and named after the table/view with the extension of the chosen export format.

 

If you have selected an export format that supports multiple tables in a single file, the Filename edit box wil be available - however, most formats will require an output folder as each table will be exported to a separate file.

 

Customizing the Export

You can select the amount of rows to export, more options may be available depending on the export format.

 

Both wizard have a page where you can select the number of rows to export. If you have a very large amount of records, you perhaps want to export a few records only - anyway, select one of the predefined options or enter a custom amount.

 

To export the result of a custom SQL statement, use the Export Result set button in the SQL Editor - the statement will be re-executed and is optimized for high speed forward only access.

 

See also: File and Folder Boxes