No other Microsoft Office 2007 system programs have as much in common as Access and Excel, but each program has its unique strengths. Where Excel offers a wide range of data analysis and presentation tools you can use to summarize your data, Access is designed to let you store, manipulate, and ask questions of large data collections. You can also use Access queries to locate and summarize table data. Although it is possible to look up data in an Excel worksheet, it’s much easier to do in Access.
Bring Access Table Data into an Excel Worksheet
In Access, display the table from which you want to copy the data.
Select the table cells you want to copy.
Click the Home tab.
Click Copy.
In Excel, click the cell where you want the first table cell to appear.
Click the Home tab.
Click Paste.
Send Excel Data to Access
In Excel, select the cells you want to copy.
Click the Home tab.
Click Copy.
In Access, display the table that you want to receive the pasted data.
In the (New) record row, select as many cells as there are columns of data to be pasted.
Click the Home tab.
Click Paste.
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 of your worksheet data into a single table cell, making the table row worthless.