Oracle Database Express Edition (XE)

Hello;

I recently converted an Access database to Oracle Database XE. The database contains mixed-case Table and Column names. My application contains fairly complex SQL which will no longer run unless I surround the table and column names with double-quotes. Doing this for all SQL statements would be fairly labor intensive.

I understand that one alternative is to alter the Table and Column names so that they are upper-case. However, I would like to continue to use mixed-case names and was wondering if there is either an Oracle OLE DB provider property or Oracle Database XE setting that will allow me to do so without having to re-code my SQL statements.

Also, if I have to alter the Table and Column names does anyone have a script that would automate the process for me?

Thank you, Pete.