Is there an easy way to query an oracle db and keep it in Access??

[ClaudiaDi]

Hello, i'm a newbie Access user, and I was requested (at work) to find if it is possible, through an SQL query or a macro, to query an Oracle database and bring the results to an Access table or database... if so, what's the procedure or the configuration?

I've been searching the web, and found a way to link tables between oracle and access, and some other information, but i don't know how to put it together to get to a conclusion whether it's possible or not... Could someone please give me a hint or a tip?? I would really appreciate it


P.S. i hope i made myself clear, since my english is kind of bad

 

[PHV]

Provided the oracle tables are linked into your access db you may build any query you want based on those tables.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886