MSQUERY: Incorrect Display of Extended Character in Field Name

The information in this article applies to:

• Microsoft Query for Windows, version 1.0
• Microsoft Query for Windows 95, version 2.0
• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In 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:

• The extended character in the field name is displayed as a plus sign (+), a hyphen (-), a vertical bar (|), or an underscore (_).

  -or-

• The extended character in the field name is displayed as the regular alpha character without the diacritical mark. Note that this behavior may occur when you use a dBASE 3 or dBASE 4 file created in Microsoft Excel.

   Non unique column reference: <column>

WORKAROUNDS

The 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.