Product Home
Export Table to SQL for DB2 Prev Page Prev Page
Product profile
Connect
User interface
Select Source Table
Data Preview
Settings Window
Command line
Database query
Select Target Table
Select Columns
Mapping
Select Target File
Text Output
SQL Output
XML Output
Excel Output
Select Objects
Select Schema Objects
Scheduling
Technical support
License
Install and Uninstall

Output text file properties

This window help you to specify properties for output to Excel spreadsheet. They are:

  • File name.
  • NULL value format (NULL or empty string).
  • First row presentation mode (should the program output column names or no).
  • Value separator (tab, comma, etc).
  • Replace option for CRLF in data cells.
  • Custom end of line delimiter.
  • Quotation mode: should the program quote ourput value.
  • Quotation sign or signs. When only one symbol is specified the program uses same symbol at both sides.
Export Table to SQL for DB2: Output text file properties Window