The program supports export to the following formats: plain text, HTML, XML and RTF (MS Word compatible).
The program allows you to select the export type for text output: delimited or fixed width. For text output you can
specify a field delimiter by entering or selecting it from the list.
There are two formats for text output: with delimiters or fixed width. The first row of the output file can contain column names. Also, the program can quote non-numeric values if necessary.
For SQL output the user can specify statement-to-statement delimiter like 'go' or ';'. Custom delimiters are available.
There are two output modes if source data has more than one table or another source:
For XML file there are two formats: column name as an attribute (<column name="A" >) or as a tag (<A>).
If you enable the "Export BLOBs" option, the program will save each binary object in a separated file with the ".bin" extension in the directory selected (by default, in current directory). The file name will contain the record number and the field number, for example, "MyTable_Record_5_Column_7.bin".
For Microsoft SQL Server and "SQL" output format there are three options for "identity" columns: