Many times you find that data from another database would be nice to have in the database you’re working on. You can bring tables (or other objects) into your database using the controls on the External Data tab. Copying tables from another database enables you to use the data as it exists at the time you make the copy, so any updates you make to the original table are not reflected in the copy, and vice versa.

Copy a Table from Another Database

1. Click the External Data tab.

2. Click Access.

3. Click Browse.

4. Double-click the database from which you want to import the table.

   Tip

   

   You can import data from other types of database objects by clicking the object type (for example, Queries) in the Import Objects dialog box and then clicking the object from which you want to get your data.

5. Select the Import Tables, Queries, Forms, Reports, Macros, And Modules Into The Current Database option.

6. Click OK.

7. Click the table or tables to import.

8. Click OK.

   
   
   

Tip

If you clicked a table to include it in the list of tables to be imported, but have changed your mind, you can click the table again to deselect it.