Microsoft KB Archive/134920

{|
 * width="100%"|

Errors with Field Names with Lowercase Characters

 * }

-

The information in this article applies to:


 * Microsoft Query for Windows, version 1.0

-

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

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

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

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

MORE INFORMATION
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.