Export Data Wizard

The Export Data Wizard allows you to export data from your MySQL table or profile query into one of the available formats: MS Excel, MS Access, MS Word, HTML, XML, SQL, PDF, DBF, RTF, TXT, CSV, DIF, or SYLK.

You can run the Export Data Wizard in one of the following ways:

from the Table Data Grid View or Query Data Grid View by selecting Export Data | Export Table toolbar or popup menu item;
by right-clicking at the table name within the Profile Window | Tables page or at the SELECT query name within the Profile Window | Queries page and selecting the Export... item from the popup menu;
by executing the data query in the SQL Executor tool and selecting the Export Data | Export Result item from the popup menu of the result grid.

The first step of the wizard allows you to select the export destination: the export file type and its name.

Select one of the available types from the drop-down list and specify the file name to export data to.

The next step of the wizard allows you to select the exported columns and adjust properties for each exported column.

The following properties are available:

Export Caption - name of the column in the result file;
Width - width of the column in the result file;
Align - text alignment in the result column.

Note, that some of the properties are type-dependent, e.g. Align is not available for MS Access, XML, and some other types.

Use the third step of the wizard to adjust data formats for the result file.

The edit boxes of this step allow you to set the format of inserting specific date/time, integer, float, or boolean values into the result file.

The picture above shows the wizard step, which allows you to set headers and footers, which appear at the top and bottom of the result file (excluding MS Access, SQL, XML, and DBF).

The next step is available only for MS Excel, MS Word, HTML, and PDF formats. It allows you to adjust the graphical design of the result file in a most easy way.

The Style Sheet list box defines the main color scheme of the result file, i.e. background and text colors of the result grid elements. The Layout box allows you to select the way of positioning grid columns and rows within the result file. All changes to Style Sheet and Layout are immediately displayed on the example image.

The final step of the wizard starts exporting, displaying the progress bar of the process.

Select the Open file within the appropriate application item to run the program, associated with the export file type (e.g. MS Excel or MS Access) and open the result file. Select E-mail file as an attachment to open your default mail client with the result file attached to the newly created message. To close the wizard without any action after the export, select the Take no action item.

To start exporting with all the parameters you have set, click the Finish button. To abort the process of export click the Cancel button in the progress dialog.