Word (OLE) Export Format

Export data to Microsoft Word document using OLE technology.

Attention! This export format has serious disadvantages:

  • It requires Microsoft Office installed.
  • Exporting can be very slow.

Use this format for small datasets or if you have significant reasons for that. Consider using other export formats, e.g. RTF.

The data can be exported to Word (OLE) format either from Database Tour (Pro) GUI or from the Database Tour Pro command line.

When exporting data from GUI, switch to Word (OLE) page of the Export dialog. If this page is not visible, click Favorite Export Formats button in the top-right corner of the window and make sure the corresponding format is selected.

Exporting Data to Word Document (Using OLE)

Format Specific Options

File - file name to export data to, when exporting data from one table or SQL query.

Folder - folder name to export data to, when exporting data from a group of tables (multi-table export). Each table will be exported to a separate file in the specified folder; file names can be specified in Table Mappings.

Table title - table title, i.e. text which is shown above the table data in the target document. Available when exporting data to one file; for multi-table exporting, table titles can be specified at the Table Mappings step. Can be blank. Command line equivalent: /TableTitle.

Append timestamp to file - append current timestamp to the end of the target file name. The timestamp mask is _YYYYMMDD_HH24MISS. Command line equivalent: /AppendTimestamp.

Include MEMO fields - include contents of MEMO / CLOB fields in target; in the latter case, a constant describing the field type will be used instead of the field contents. Command line equivalent: /IncludeMemo.

Include column names - include the column headers in the target. Command line equivalent: /IncludeColNames.

Trim trailing spaces - trim trailing spaces and control characters in target. Applicable for char and varchar data only. Using this option allows to remove useless data and thus reduce the output volume, and sometimes improve the target look. Command line equivalent: /TrimTrailingSpaces.

View

View options for target tables. Note: Using these options can slow down the exporting process.

Use GUI settings - use GUI table view settings for target tables. When using this option, each table in target document will acquire the look of the corresponding GUI data grid (its fonts and colors, including conditional formatting); otherwise, default view settings will be applied. Command line equivalent: /UseGUIViewSettings.

Alternate row color - background color for every second row. The color must be specified in hexadecimal form, which is made up of sharp symbol (#), followed by three hex numbers, rr, gg, bb, that give values for red, green and blue, respectively; for example, #FF0000 represents red. If you don't want to highlight even rows, leave this field blank. Command line equivalent: /AlternateRowColor.

Table title font - font for the Table title. Command line equivalent: /TableTitleFont.

Column headers font - font for the column headers. Command line equivalent: /ColumnHeadersFont.

Rows font - font for the target data rows. Command line equivalent: /RowsFont.

Export mode

REPLACE+INSERT

Target file is created and filled with incoming rows; if the target file already exists, it is overwritten.

CREATE_OR_REPLACE

Blank target file (using appropriate structure) is created; if the target file already exists, it is overwritten.

Note: For multi-table exporting, the value can be overridden for each individual table-to-file pair in Table mappings section.

Command line equivalent: /ExportMode.

Record range

Range of source records to be exported:

  • Full table - all records are exported.
  • Selected records only - only selected records are exported. To select rows, click the corresponding button and then select needed rows using Shift, Ctrl and arrow keys.
  • From current record to the last one - all data between current and the last records are exported.

Limit the record count to - maximum number of records to be exported. If this option is not specified or it is less then 1, all records from the specified record range will be exported. If you just want to create a file without data exporting, use the corresponding Export mode instead. Command line equivalent: /LimitRecordCount.

Column range

Range of source columns to be exported:

  • All columns - all columns (including columns, which were temporary hidden by user) are exported.
  • Selected column only - only selected (current) column is exported.
  • Visible columns - only visible columns are exported.

Source records per target row

Number of records from source database to be placed into one line of the target file. For example, if you specify 2, the source data will be placed to the target in the following way:

Source Target
Col1 Col2   Col1 Col2 Col1 Col2
cell1 cell2  >>  cell1 cell2 cell3 cell4
cell3 cell4   cell5 cell6 cell7 cell8
cell5 cell6          
cell7 cell8          

This option is useful when source have a small count of columns and a large count of rows. Using it, you can fill target area more optimally.

Command line equivalent: /RecordsPerLine.

Other options

Ask before overwrite or empty existing target - ask the user to overwrite existing target for REPLACE+INSERT and CREATE_OR_REPLACE export modes. Reverse command line equivalent: /SuppressOverwriteOrDeletePrompt.

See also