Data Export

Database Workbench offers two wizard for easy exporting of data to different file 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.

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

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.

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.

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.