Because data imported from one Access database to another is already in Access formats, these transfers usually go relatively smoothly.
The easiest way to move data between Access databases is to copy and paste tables, as follows:
Right-click the table in the source database and choose Copy.
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.