O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

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

Importing Access Data

Because data imported from one Access database to another is already in Access formats, these transfers usually go relatively smoothly.

Copy and Paste

The easiest way to move data between Access databases is to copy and paste tables, as follows:

1.
Right-click the table in the source database and choose Copy.
2.
Switch to the target database and paste the table. The dialog box in Figure 13.22 appears. If you click Structure Only, the new table will contain the fields of the original table but none of its data. Structure and Data pastes the entire table. Append Data to Existing Table is self-explanatory; for Table Name, instead of naming a new table, you supply the name of the table to which you want to add the records.

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