Export Data Dialog guides you through the process of exporting table data.
Formats. Use this tab to set the type of the result export file. According to the
type you select, the file extension is changed automatically in the Destination file edit
Options. Use this tab to set general export options. If Go to the first record
is checked, then export starts from the first table record. Set the number of first records
to skip, if necessary, in the Skip ... record(s) field. Choose, if all the table
records should be exported (Export all records, default) or set the limit of records to export
in the Export only ... record(s) field.
Destination file - use this edit field to set the name of the export destination file.
Use Select button to fasten this process.
Open file after export - check this option to view the result file in associated
program after export.
Print file after export - check this option to print the result file after export,
using your default printer settings.
Save Template/Load Template - use these buttons to save/load to/from template file
all export configuration settings, such as: export type, filename, exported field list,
formats, and so on.
Use this tab to select fields for export. Available fields is a list of the source
table fields, Exported fields list contains fields, selected for export.
To move all the fields from one list to another click the double arrow buttons (>> or
<<) or drag and drop fields from one list box into the other (use Shift or
Ctrl to select multiple fields). To move only the selected fields click the single
arrow buttons (> or <), drag and drop the field from one list box into the other
or double-click the field.
If you don't select any fields for export, then all the table fields are exported by default,
Standard. Use this tab to define the formats of the exported fields. You can keep
the default format values or edit some of them if necessary.
User. Using this tab you can also define your own formats for numeric and
Date/Time fields. These fields (if there are any in your table) are available in the
drop-down list at the top of the panel. Choose one of them, then choose its format from another
drop-down list and click Add. The field and its format will be added to the list box
below. To edit the field format select the field in the list box and click Edit. To
delete one click Delete. To clear the list box click Clear.
This tab is unavailable for DBF export type.
Header & Footer:
Use this tab if you want some header or footer text to appear in the result
document. You can define this text in the appropriate memo fields of this tab.
This tab is unavailable for XML and DBF export types.
Caption & Align:
Allow captions - if this option is checked (default), the column captions are
included into the result file.
Use grid to set the captions of the result table columns. Default column captions correspond
to the database field names.
For some of the export types columns Width and/or Align are also available. In
the Align column you can select the text alignment for the certain column (Left, Right
or Center). In the Width column you can set the numeric value, defining the width of the
This tab is unavailable for DBF export type.
This tab is available only if the chosen export type is HTML.
Preview. This tab allows you to define the colors of various elements of the result
HTML document, such as: default font color, header font color, table font color, background
colors and link colors. To change the color of some element just click this element and set
the color you need. You can also use various HTML templates to make the result document look
in the way you need. Select a template from the Template drop-down list or click Load
template to browse for templates. If you have changed some HTML elements manually and you
like the result, you can save it as a template for future using by clicking Save as template
Basic. This tab allows you to define the title of the result document and set the mode
of the CSS (Cascade Style Sheets) using. The default CSS using is internal, but
you can set to external and define your own CSS file in the CSS file name edit field.
Advanced. On the Body options panel you can set the default font name of the result
document and set the document background. In the Advanced attributes edit field you can
define any attribute values for the HTML tag <BODY>.
The Table options panel allows you to define such attributed as CellPadding,
CellSpacing and Border. In the Advanced attributes edit field you can
define any attribute values for the HTML tag <TABLE>.
The Multi-file export panel allows you to export your data not to a single HTML document,
but to a number of documents. Check option Use multi-file export to enable this mode and
define the maximum number of records in each result file in the appropriate edit field.
This tab is available only if the chosen export type is MS Excel.
Data Format. This tab allows you to define a specific format for each data column,
header, footer, column captions and aggregate functions. Select the field from the Fields
list or select an element of the result Excel sheet (captions, footer, etc.) from the
Options list and set its font, borders and fill. All the changes you make are displayed
in the sample cell. For data columns you can also define aggregate functions (Aggregate tab):
AVG (average value), MAX (maximum value), SUM (sum of the values), and
MIN (minimum value). The aggregate function is added to the cell under the column.
Click Reset item to reset all format setting for the current item, click Reset all
to reset format settings for all items.
You can also define repeating styles for data columns or rows on the Styles tab.
Click button to add
a style and set its format. After you define all the styles, set the strip style to Col
or Row (on this depends if these styles will be applied to columns or rows). To delete
a style, use button .
To load and save styles use buttons
Advanced. This tab allows you to define headers and footers of the result document pages
(the default page footer is page number) and the sheet title.
This tab is available only if the chosen export type is MS Word or RTF.
It allows you to define properties of the default document font, row header font and page orientation
(portrait or landscape).
This tab is available only if the chosen export type is XML.
It allows you to set the encoding of the result XML document and define if the result document
will be standalone by checking/unchecking Standalone option.
This tab is available only if the chosen export type is Text File or CSV.
TXT Options. If option Calculate column width is checked (default), then width
of each column in the result file is set automatically depending on the maximum number of
symbols in the column cells. Spacing sets the distance (in symbols) between the data columns
in the result file.
CSV Options. If option Quote Strings is checked, then all the strings are
exported as quotations, and the apostrophes are doubled. Comma defines the symbol,
delimiting columns in the result file.
When you are done, click the Start Export button to begin export or click Cancel to cancel export.