APPLICATION DESIGN

Writing a COL file for a worksheet
To import worksheets using COL files, use these keywords:

WKSCOL

This keyword allows you to associate a field name with a specific worksheet column. The syntax for a statement using this keyword is:


Where:
Only columns specified by the WKSCOL keyword will be imported.

RANGE

This keyword specifies the worksheet range to be imported. The syntax for a statement using this keyword is:


Where:
The range must be a valid range name in the imported file.

If you use a RANGE statement, the first WKSCOL statement in the COL file must refer to the first column in the range. For example, if the range starts at column D, the first WKSCOL statement in the COL file must be:


Note that a RANGE statement in a COL file overrides any range name entered in the Worksheet Import Settings box.

See Also