I want Access to import an Oracle table..

G

Guest

How do I get Access to see my Oracle tables. What, on Access, do a click?
The odbc driver seems to be set up.
 
K

Keith Wilby

NotAnMSfan said:
How do I get Access to see my Oracle tables. What, on Access, do a click?
The odbc driver seems to be set up.

You need to set up an ODBC connection to your Oracle system using a valid
username and password. You do this by selecting "Link tables", then in the
file type drop-down select ODBC Databases(). You can then choose the data
source and supply the logon credentials.

HTH - Keith.
www.keithwilby.com
 
G

Guest

Keith Wilby said:
You need to set up an ODBC connection to your Oracle system using a valid
username and password. You do this by selecting "Link tables", then in the
file type drop-down select ODBC Databases(). You can then choose the data
source and supply the logon credentials.

HTH - Keith.
www.keithwilby.com
 
G

Guest

Related Question:
When I choose the ODBC() option in the dropdown, the dialog box goes away.
Any thoughts ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top