Microsoft KB Archive/113317

= Case Sensitive Table Names Not Recognized =

Article ID: 113317

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Query 2000

-



This article was previously published under Q113317



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

