Microsoft KB Archive/61549

Mplan: “Not a Valid Extract Range” Using Run Database Extract PSS ID Number: Q61549 Article last modified on 06-18-1990 PSS database name: D_MPlan

4.00 4.01 4.20

MS-DOS

Summary:

To correctly extract information from a Multiplan database range, the field names for the extracted information must be listed in the Run Database Extract “to cells:” field. If the database field names are not included, the error message “Not a valid extract range” will be displayed. It is not necessary to include all of the database field names as part of the extracted information.

Note: In the following example, the field names are included as part of the database, criteria, and extract ranges:

Database Range
Name Address City —- ——- —-

Joe 1212 So. Smalltown Sam 4545 No. Anytown Jill 6767 E. Bigtown

Criteria Range
Name Address City —- ——- —-

=&J*

Extract Range
Name City —- —-

Joe Smalltown Jill Bigtown

The extract range may be named using the Name command. Make sure that the field names are in the first line of the named area.

Copyright Microsoft Corporation 1990.