Export/Import Tab Default Preference Settings - SQL Assistant

Preferences

Default

Description

ColumnDelimiter

{tab}

Use a tab character as the delimiter between columns in export and import files

ColumnQuote

Do not enclose the data fields in quotes (or expect in Import)

ExportOneFile

False

Export results from multiple statements to separate files

ExportWriteSQL

False

Do not write SQL and result status to the export file

ExportWriteHeader

True

Write column headers to the export file

ExportWriteBOM

True

A Byte Order Mark is written to the start of all Export files

ExportRowNum

True

An AutoNumber column is added as the first column in any table created for an Export to Access operation

RemoveCrLf

False

Do not remove carriage returns from exported text values

LimitExports

False

Do not prompt the user when the Answerset row limit is reached

ImportConvert

False

Do not convert the localized decimal point to a period on import. (Option is only enabled when the decimal point is not a period.)

ImportSkipHeader

False

Do not skip the header record (first line) of imported files

ImportBatchSize

20

Submit 20 rows worth of data at a time when Importing data (not ODBC)

ImportIgnoreError

False

Do not ignore errors, such as duplicate inserts, when using Batch Import