Microsoft® Office Access™ 2007 Plain & Simple

Getting Data from Other Access Tables

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 ...