Copy Access Data to New Records

Fewer steps

The Paste Append feature is often overlooked in Access.

This feature lets you quickly create new records that copy existing information from other records.

To see one way to use the feature, open a table in Datasheet view.

1. While holding down the [Shift] key, select adjacent fields with data you want to copy. You can also select fields from adjacent records.
   
2. When you've finished, press Ctrl+C to copy the data.
   
3. Then, choose Edit>Paste Append (Paste>Paste Append in 2007+)
   
4. 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.



See all Topics