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 Delimiter | Row delimiter |
Field Delimiter | Field delimiter |
Literal Quote | Character to use for string escaping |
Date Quote | Character 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