Microsoft Query and Oracle

D

dalssoft

Hi,

I'm trying to use Microsoft Query (Office 2003 SP2) and Oracle 9i but
it is not working for two reasons:

1. The table's and column's names on Oracle DB are case-sensitive.

Error: "Can't access table TABLE1"

2. It is not possible to use "auto-link". I tried to use with another
DB that is not case sensitive and when I add two related tables (FK)
it does not show me the link between them.

ODBC: Microsoft ODBC for Oracle

Any information to fix it? Hot fix? Service Pack? Setup?

It is very important that Excel works with Oracle.

Thank you,

David
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top