Microsoft Access: Quickly copy data to new records

The Paste Append feature lets you quickly create new records that copy existing information from other records.

1. Open your table in Datasheet view.
2. While holding the SHIFT key, select adjacent fields with data you want to copy. You can also select fields from adjacent records.
3. Copy the selected data.
4. From the Edit menu, select Paste Append and click Yes when Access asks for confirmation.

You’ll now have an appropriate number of new records in the table that contains the information you copied.

If you have any questions regarding this tip or need help implementing it in your own projects, contact Ranelle Maltas, Application Support Associate, at 472-0585 or e-mail at rmaltas2@unl.edu.