Microsoft Office Tutorials and References
In Depth Information
Exchanging data between Access and Excel
Send Excel data to Access
1 In Excel, select the cells that you want to copy.
2 Click the Home tab.
3 Click the Copy button.
4 In Access, display the table that you want to receive the pasted
5 In the (New) record row, select as many cells as there are columns
of data to be pasted.
6 Click the Home tab.
7 Click Paste.
8 Click Yes to acknowledge that you want to paste the worksheet
data into the table.
CAUTIoN If you click only a single cell in the Access table’s
New record row, you’ll paste all your worksheet data into a
single table cell, making the new data worthless.