How to Use Access 2007 to Connect to Oracle

The Microsoft Office Access 2007 database manager application includes several importing features that allow you to import external data. For example, you can choose to import an ODBC database file, which includes Oracle databases. Before you import the data from your Oracle database, you must make sure the Oracle file meets your preferences and is saved to an easy-to-find location on your computer. The Oracle data can then be sent to your Access 2007 database as a new table.

• 1

  Open the Microsoft Access 2007 database file on the same computer where you will import the Oracle data.

• 2

  Click the "External Data" tab from the top of the application and then select the "More" option.

• 3

  Click the "ODBC Database" option and then the Get External Data dialog box will appear on your screen.

• 4

  Select the "Import the source data into a new table in the current database" option and then click the "OK" button.

• 5

  Click the Oracle database file you want to import in the Select Data Source dialog box. Select the tables you want to import from the Oracle file and then click the "OK" button. The Oracle tables will then be imported into your Access database.