Home >> FAQs/Tutorials >> Oracle Tutorials
Oracle Tutorials - Connect MS Access to Oracle Servers
(Continued from previous topic...)
How To Connect MS Access to Oracle Servers?
Once you got a DSN defined in the ODBC manager that connects to an Oracle server,
you can connect a normal MS Access document to the Oracle server, and link an Access table
to Oracle table. The tutorial below gives you a good example:
- Start MS Access with a new database file.
- Go to File menu.
- Select Get External Data.
- Select Import.... The Import dialog box shows up.
- Select Files of type: ODBC Database(). The Select Data Source dialog box shows up.
- Click the Machine Data Source tab. You should see the DSN name "FYI_DSN" you defined earlier.
- Select "FYI_DSN".
- Enter User Name: fyi.
- Enter Password: retneciyf.
You should see the Oracle ODBC Driver Connect dialog box as shown in the picture below:
Click the OK button to continue. You should see a list of tables available for you to import
from the Oracle server as shown in the picture below:
(Continued on next topic...)
- What Is Open Database Communication (ODBC)?
- How To Install Oracle ODBC Drivers?
- How To Find Out What Oracle ODBC Drivers Are Installed?
- How Can Windows Applications Connect to Oracle Servers?
- How To Create Tables for ODBC Connection Testing?
- How To Verify Oracle TNS Settings?
- How To Define a Data Source Name (DSN) in ODBC Manager?
- How To Connect MS Access to Oracle Servers?
- How To Connect ASP Pages to Oracle Servers?