MSQUERY: Incorrect Display of Extended Character in Field NameLast reviewed: March 27, 1997Article ID: Q124231 |
1.00 2.00
WINDOWS
kbtool xlquery
The information in this article applies to:
SYMPTOMSIn Microsoft Query, when you use a Paradox, dBASE, or Microsoft FoxPro data source, and you add a table with a field that contains an extended character, one of the following may occur:
Non unique column reference: <column>where <column> is the column name as displayed in the table.
WORKAROUNDSThe best way to avoid this behavior is to avoid using extended characters in field names when you create a table that you are going to use in Microsoft Query. However, if you must use extended characters in the table field names, make sure that the field names differ from each other by more than just the extended character. In Microsoft Query, version 2.0, you may not receive an error message when duplicate field names are added. However, the duplicate fields will only show values from the first occurrence of the field name.
|
KBCategory: kbtool
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |