Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query based on Oracle and MS Access connections

902999Nov 30 2011 — edited Nov 30 2011

I hope this is in the correct spot.

I am using Oracle SQL Developer to extract data from some Read Only tables in Oracle.

What I would like to do it have a list of numbers in a MS Access database to select the same number from Oracle tables, then export the data out to Access or Excel. There may be several thousand numbers at a time.

I asked if they would give me one table with one column in Oracle I could read/write to but the answer was no.

I have my connection strings working to both the Oracle tables and to the Access database but i can not figure out how to build a query using both tables.

If I build a query to the Access table can I use that query somehow in the query of the Oracle table?

Thanks
Steve

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 28 2011

Added on Nov 30 2011

#general-database-discussions

6 comments

728 views