From Access DataBase to Oracle DataBase

[richardn]

I have two databases : the first is a MS Access XP DataBase and the second is an Oracle one.
In MS Access I have a table (A) containing my customers, and in Oracle I have a table (B) with all customers (including my customers). The key is the same key in both databases (CustomerID).
I am interested to run a query that selects from B table (from Oracle) records about customers (for example customers grades) from A table ( in Access), I mean to create a inner join from A to B.
I want to run the query from Access, as a SQL Statement or a query, doesn't mater.
I have instaled on my computer the Oracle Client ( 8.1.7 ) and I can create an "ODBC Driver" for the Oracle database.
It's possible to do that?
Please somebody help me.
Thanks,
Richard

 

[FoFa]

You have 2 options. You can either link the Oracle table, or create a pass through query to pull the data you wish, and then you can join either the table or query. That's the easy part. Getting the Oracle connection to work, now there is the tough part.