Case Sensitive Table Names Not Recognized (113317)

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