Data Export

Previous  Top  Next

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.


Currently, the following formats are supported:





SQL INSERT INTO statements


Database Workbench Export - multi table export format


dBase File


Padded Text File


Microsoft Excel® File


Comma Separated Values File


Lotus 1-2-3 File


Data Interchange Format


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