I want Access to import an Oracle table..

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
Click to expand...

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
 
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
Click to expand...
 
Related Question:
When I choose the ODBC() option in the dropdown, the dialog box goes away.
Any thoughts ?
 
You must log in or register to reply here.

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

Similar Threads

Linking to selected fields in an external table 4
Database name added to link tables! 1
Can't get real oracle error with Access error 3155 0
Setting up ODBC programmatically 3
Oracle ODBC Connection Problem 1
How to login "Oracle ODBC Driver Connect" in the programmatically 1
Access 2007 linked to Oracle 3
ODBC - Connecting MS Access to Oracle 10g 2

Back
Top