MSQuery: Case Sensitive Table Names Not Recognized

 Last reviewed: March 27, 1997
Article ID: Q113317
1.00 2.00 WINDOWS kbusage kbtool

The information in this article applies to:

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

SQL Server is a case-sensitive back-end application. This means that a table named "addr" is distinguished from a table named "ADDR." However, because Microsoft Query is an MS-DOS-based application, it is unable to distinguish cases; therefore, Microsoft Query views "addr" and "ADDR" as the same file.

If you add a table to MS Query from an SQL server and the table is titled "addr," and you then attempt to add a second table titled "ADDR," you will receive the following error message: 

   Table ADDR is already in the query: add it again?
If you choose OK, the second table will be added with the correct data but will be displayed in the table pane as addr1 (the case of the first table name followed by the number one).

REFERENCES

"Microsoft Query User's Guide," pages 27-28.

KBCategory: kbusage kbtool
KBSubcategory: xlquery xlwin

Additional reference words: 5.00 7.00 Query
Keywords : xlquery xlwin kbtool kbusage
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.