The information in this article applies to:
SYMPTOMS
In Microsoft Query, when you create a query using the Microsoft Excel
data source, and you add a field or multiple fields to the query so
that the number of fields in the query is greater than 255, you
receive the following error message:
CAUSE
In Microsoft Query, you cannot add more than 255 fields to a query
created with a data source that uses the single-tiered driver. Data
sources that use the single-tiered driver are dBASE3, FoxPro, Excel,
Paradox, Access 1.0, dBASE4, and Btrieve.
Q110601 Microsoft Query: dBASE Files and Field Limits REFERENCES
For more information about how to Add Fields (Cue Cards), choose the
Search button in Help and type:
Additional query words: 5.00 5.00c ISAM
Keywords : |
Last Reviewed: July 15, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |