Command Overview

The query command is used to extract data from a database and copy the data to a work sheet. There is no report. The command supports only a database datasource, e.g. MySQL, MS-Access, etc.

Syntax

The command is entered on the command line as the command name ("qu") followed by one or more command parameters. Each command parameter consists of an argument name, immediately followed by an equal sign ("=") and then immediately followed by a value. The value may be enclosed with quotation marks, and must be enclosed by quotation marks if the value consists of any embedded spaces.

An example of a command parameter to specify that the file name to be processed is test.txt is entered as "file=test.txt" (without the quotations). Each argument on the command line must consist of only valid parameter names. If a required parameter name is missing, then the command line will be colored yellow, an error message will be displayed on the Excel status bar and an audible tone will be sounded.

The following is a listing of all parameter values for the query command:

An example

The command to extract selected columns from the table "je" and store the data on a worksheet named "qu1", is as follows:

qu ds=db conn="C:\Program Files\EZS\XLAC\data\test.mdb" sql="select number, amount, acctno, accttype, desc, source from je" recap=qu1

Output from the processing will be a worksheet containing the data from the database extract

An example of the command bar is shown below:

An example of the worksheet extract is shown below:

Main Form