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.
- While holding down the [Shift] key, select adjacent fields with data you want to copy. You can also select fields from adjacent records.
- When you've finished, press Ctrl+C to copy the data.
- Then, choose Edit>Paste Append (Paste>Paste Append in 2007+)
- Click Yes when Access asks for confirmation.
See all Topics