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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.