I'm assuming you already have access over a network to the servers where the Oracle data source is located. You will need the data source name, and a user name and password for the Oracle data source before starting.
In the Control Panel, click on Data Sources (ODBC). Look at both the System DSN and User DSN tabs to decide where you want to create the data source. Click on Add, select a driver (I use the generic MS ODBC for Oracle driver) and enter the data source, user name, and password.
Once this source is set up, you then open your Access database, File/Get External Data/Link Tables, and choose an ODBC Databases as the file type in the box that pops up. You will then see a box similar to the one in the control panel - click on the Machine Data Source tab. Just choose the source you created there and type in you password.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.