Link to home
Start Free TrialLog in
Avatar of renewest
renewest

asked on

How to access Access from Oracle

I have some data in an MS Access datafile.
How do I set up things so that I can run SQL queries against this database from an Oracle database.

I tried to read the "Oracle9i Heterogeneous Connectivity Administrator's Guide" but that somehow lack some hands on examples.

I think I need to:
Create a DSN (ODBC datasource)?
Create a database link?

I run everything in a Win2k environment.

thanks Rene
ASKER CERTIFIED SOLUTION
Avatar of Datamonkey
Datamonkey

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial