Exchanging Data between Access and Excel

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

  1. In Access, display the table from which you want to copy the data.

  2. Select the table cells you want to copy.

  3. Click the Home tab.

  4. Click Copy.

  5. In Excel, click the cell where you want the first table cell to appear.

  6. Click the Home tab.

  7. Click Paste.

    Bring Access Table Data into an Excel Worksheet
    Bring Access Table Data into an Excel Worksheet

Send Excel Data to Access

  1. In Excel, select the cells you want to copy.

  2. Click the Home tab.

  3. Click Copy.

  4. In Access, display the table that you want to receive the pasted data.

  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.

    Send Excel Data to Access
    Send Excel Data to Access

    Caution

    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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.189.171.125