O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required