MSQuery: Case Sensitive Table Names Not Recognized

ID: Q113317

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.

Additional query words: Query

Keywords : xlquery xlwin
Version : 1.00 2.00
Platform : WINDOWS
Issue type :