Customizing QUERY

QUERY > Managing QUERY > Customizing QUERY

Back to

Application Defaults

In QUERY, you set options from the Options button on the Tools tab.

The Application Defaults settings contain:

Type any of the default file paths for the following files:

Result files: specify Excel, Access, or text
Query files (.qsq files)
Log files and trace files
Auto logon file
Data Dictionary. You can set the location where the data dictionary is saved. You can even save to a location on a network. Ensure that you have read/write permissions for the folder that is set as the data dictionary location.

Sheet name: Default Excel sheet to use when running your query file. The default is Sheet 1.

Start row: The default row is 2.

Log Column/Cell: Specify the default column or cell into which log information is written.

If Excel files take a long time to open or if the add-in is incompatible with the Excel add-in or with other applications.

Default number of records to download: Specify the default number of records for each download.

Also in this section