Errors with Field Names with Lowercase Characters

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

REFERENCES

For additional information, please see the following article(s) in the Microsoft Knowledge Base:

Q109486 BUG: Oracle Driver Fails to Find Delimited Identifiers

Additional query words:

Keywords : xlquery
Version : WINDOWS:1.0
Platform : WINDOWS
Issue type :