ID: Q134920
1.00 WINDOWS kb3rdparty
The information in this article applies to:
In Microsoft Query, you may receive an error message similar to one of the following when you access an Oracle table:
ORA-00942: table or view does not exist.
-or-
ORA-00904: invalid column name.
If the name of the table itself contains lowercase characters, you will receive the first error message. If the name of a field within the table contains lowercase characters, you will receive the first error message.
If the Oracle table was exported from another application, such as Microsoft Access, change the names of any table or fields so that they are in all uppercase characters. For example, change the field name "MyField" to "MYFIELD." Then, you can export the tables back into Oracle.
Microsoft has confirmed this to be a problem in Microsoft Query version 1.0 for Windows. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
In general, Oracle versions 6.0 and 7.0 use uppercase characters for database object names, such as tables and views. Any Oracle tables or field names that contain lowercase characters have usually been imported from another application, such as Microsoft Access. These tables and field names will cause problems if you use Microsoft Query to access them.
Oracle is manufactured by Oracle, Corp., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.
For additional information, please see the following article(s) in the Microsoft Knowledge Base:
ARTICLE-ID: Q109486
TITLE : BUG: Oracle Driver Fails to Find Delimited Identifiers
Additional reference words: 1.00
Keywords : xlquery
Version : 1.00
Platform : WINDOWSLast Reviewed: September 15, 1996