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. |
Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
