How to access Access from Oracle
Posted on 2003-03-11
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.