Setting Export Options
Use the following procedure to set export options in the Options dialog box. See “Setting Export/Import Options” on page 131 for more information on setting the Export/Import tab and “Setting Import Options” on page 133 for Import tab settings.
After selecting any of these options, follow the instructions on “Exporting Results” on page 129 to learn about exporting results.
1 Select Tools > Options.
2 Click the Export tab.
3 Select the options you want.
The following table explains each option.
Option |
Description |
Write all exported answer sets to a single file |
Writes the output from a query that contains multiple select statements to a single file. The default value of this option is cleared, meaning output from a query that contains multiple select statements is written to multiple files. |
Write the SQL and result status to the export file |
Writes the SQL and result status to the export file. The result status is the rows processed, elapsed time, and error messages (if any occurred). The default value of this option is cleared, meaning the SQL and result status is not written to the export file. |
Write column headers to the export file |
Writes column headers to the export file before the data is written. Clearing this
option might be useful if you plan to Import the data back into the database at a
later time. If this option is not selected, no column headers are written. |
Replace Carriage Returns in column data with blanks |
Replaces carriage returns in column data with blanks when exporting to text files.
If this option is not selected, carriage returns are left as is. |
Write Byte Order Mark [BOM] to unicode export files |
When selected, all unicode or UTF8 export files include a BOM at their beginning. |
Include a Row Number column in Microsoft Access export tables |
When selected, an AutoNumber column is defined as the first column of a new export
table. This column contains the row number of that row. |
Honor the Answerset row return limit during exports |
When selected, exported result sets are terminated when they reach the Maximum Row
Limit set on the Answer tab. If there are multiple result sets, the limit applies
to each individual set. |
For more information, see “Default Preferences (Options)” on page 156.