# How to Connect an MS Access Database to an Oracle Database

> To connect an MS Access database to an Oracle database, navigate to External Data, select ODBC Database, choose your data source, click Machine Data Source, create a new connection, select a data source type and Oracle driver, and click Finish to log in and pick your database.

Canonical: https://livedemo.ai/tutorials/how-to-connect-an-ms-access-database-to-an-oracle-database/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3337ab56e05a00fd73c5/preview?step=1

## Steps

1. Inside the main dashboard of your MS Access database, navigate to the top menu bar and click 'External Data'.
2. Choose 'ODBC Database' from the available options under Import & Link.
3. Subsequently, select the data source and destination you prefer to use. Once done, click 'OK' to continue.
4. Tap the 'Machine Data Source' tab afterwards.
5. Next, click 'New' to create the connection.
6. Select your preferred type of data source, then click 'Next'.
7. Following that, choose the specific Oracle driver you wish to use and then click 'Next'.
8. Finally, click 'Finish' to log into your active Oracle account and pick the specific database you wish to connect to your MS Access database.