Paste Data From Another Source

To paste data from an Excel Worksheet or Word Table:

Select the data to be copied. Click Copy on the Home Tab, Clipboard Group. Navigate to the Access table in which you wish to paste the data. Place the cursor on the table where you would like to paste the data. Click Paste on the Home Tab, Clipboard Group.