MSQUERY: Incorrect Display of Extended Character in Field Name

Last reviewed: March 27, 1997
Article ID: Q124231
1.00 2.00 WINDOWS kbtool xlquery

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.

Additionally, if the only difference between any two field names is the extended character, such as All (where A is the letter A with the caret symbol) and All (where A the letter A with the dieresis symbol), you receive the following error message when you add a field to the Data pane

   Non unique column reference: <column>

where <column> is the column name as displayed in the table.

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.


KBCategory: kbtool
KBSubcategory: xlquery

Additional reference words: 1.00 2.00 5.00 5.00c 7.00
Keywords : xlquery kbtool
Version : 1.00 2.00
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 27, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.