tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities DigMinecraft
Share this page:

MS Access: Import a table from another database in Access 2007

See solution in other versions of Access:

Question: In Microsoft Access 2007, how can I import a table from another database?

Answer: You are able to import tables from other databases, whether the table is an Access table, an Oracle table, an Excel spreadsheet, or even a text file.

Importing a table from another Access database

To import a table from another Access database, select the External Data tab in the toolbar at the top of the screen. Then click on the Access button in the Import group.

Microsoft Access

Next, click on the Browse button and find the Access file that contains the tables that you wish to import from. In this example, we are selecting the Testing2.accdb file.

Then select the radio button called "Import tables, queries, forms, reports, macros, and modules into the current database" and click on the OK button.

Microsoft Access

Highlight the tables that you wish to import. In this example, we have selected the Suppliers table.

When you have finished selecting the tables, click on the OK button.

Microsoft Access

You have the option now of saving your import steps. Click on the OK button.

Microsoft Access

Your imported tables should now appear in your database window.

Microsoft Access

Importing a table from an Oracle database

To import a table from an Oracle database, select the External Data tab in the toolbar at the top of the screen. Then in the Import group, click on the More button and select ODBC Database from the popup menu.

Microsoft Access

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

Microsoft Access

A "Select Data Source" window should appear. Click on the Machine Data Source tab and select the ODBC connection for your Oracle database. In this example, we have chosen an Oracle database called "Prod". Click on the OK button.

Microsoft Access

A login window should appear. Enter your user name and password for the Oracle database. Click on the OK button.

Microsoft Access

Now you can select the Oracle tables that you wish to import.