ACC: ORACLE Tools Do Not Recognize Exported MS Access Tables

• Microsoft Access versions 2.0, 7.0

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

ORACLE tools do not recognize Microsoft Access tables that you have exported.

CAUSE

ORACLE tools reference all database objects (such as table names) in uppercase letters. If you export a Microsoft Access table whose name contains mixed uppercase and lowercase letters, ORACLE tools such as SQL*Net and SQL*Plus will not recognize the table.

RESOLUTION

To use the ORACLE tools on an exported Microsoft table whose name contains mixed uppercase and lowercase letters, place double quotations marks around the table name (for example, SELECT * FROM "Customers").

Another workaround to this behavior is to rename your tables using only uppercase letters and then export them again.

STATUS

This behavior is by design.

MORE INFORMATION

Microsoft Access sends information to and retrieves information from ORACLE as literals, placing quotation marks around table and field names. This causes ORACLE to store Microsoft Access table and field names as literals, retaining the mixed uppercase and lowercase letters. ORACLE only recognizes names that contain only uppercase letters.

The third-party products discussed here are manufactured by Oracle Corporation, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.