Microsoft Office Tutorials and References
In Depth Information
Importing and Exporting Your Excel Content
To take your Access table and add it to an Excel
worksheet, follow these steps:
Once you paste your content, you’ll probably
need to widen certain columns to accommodate
longer entries or adjust cell formatting—to
format dates or numeric content properly, or
to change the appearance of text. Figure 14-37
shows the raw content, with no such formatting
applied yet. Note the text wrapping in cells, and
the pound signs showing where numeric values
can’t fit within the width of the column. To find
out more about the formatting process, review
Chapter 5, “Making the Worksheet Look Good.”
1. Open your Access database, and then open
the table that you want to use in your Excel
2. Select the entire table, as shown in Figure
14-36. You can also select just a few rows or
columns, as desired.
Paste Option Pop-Up
An Access table awaits copying and pasting
into an Excel worksheet.
3. Copy the cells by choosing Copy from the
Home tab, or right-click the selection and
choose Copy from the pop-up menu.
4. Switch over to Excel, and click in the cell
where the Access content should begin.
5. Press Ctrl + V (or click Paste from the Home
tab). The table cells from Access now appear
in your worksheet, as shown in Figure 14-37.
Access table content is an easy contribution to an
Excel worksheet. You can ignore the Paste Option
pop-up, as all formatting from Access (that’s
applicable in Excel) will come with it by default.