Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Connecting to Oracle via Access
- Thread starter dmaranan
- Start date
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.
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.
- Status
Similar threads
- Locked
- Question
- Locked
- Question