Import / Export Options


These options control settings used when generating export files

 

Date Format

Date format used when exporting to CSV files and it also used when generating SELECT, INSERT, UPDATE statements

 

Delimited File Export Options

    Row DelimiterRow delimiter
    Field DelimiterField delimiter
    Literal QuoteCharacter to use for string escaping
    Date QuoteCharacter to use for date escaping

 

XML File Export Options

Data as Attributes - controls if data exported as XML attributes instead of values

 

Excel Export Options

Preserve Leading Zeroes - applies to character columns which look like numbers with leading zeroes 0000032.

If this option not checked than Excel will convert string to number and leading zeroes will be lost.

If this option checked than value will be exported to Excel with number format set to "@" which will preserve leading zeroes.

Smart Excel export uses this setting regardless of if it checked or not.

 

Preserve DECIMAL and Preserve BIGINT exports numbers to Excel as values with number format set to "@".

This preserves number precision and prevents Excel from displaying them in scientific notation.

 

Excel Export Templates allows to specify excel file for export.

Excel template should be specified in format: file_name,range_name (C:\Temp\export.xls,R_RESULTS_OUT)

Export templates can be selected from right click menu in Results Grid