Database Reference
In-Depth Information
3
Display the blank Excel worksheet. Then with cell A1 selected, on the Excel Home tab,
in the Clipboard group, click the Paste button.
KEYBOARD SHORTCUT Press Ctrl+V to paste a cut or copied item from the Clipboard.
The Access field names have become Excel column headings.
4
Switch back to the Access database.
Now let's copy and paste only a few fields of a few records.
10
5
In the FirstName field, point to the left border of the value Ted , and when the
pointer changes to a thick cross, drag down and to the right until the FirstName
through Region fields are selected for six records.
6
In the Clipboard group, click the Copy button.
7
Switch back to Excel, click cell A9 , and then in the Excel Clipboard group, click the
Paste button to paste in the new selection, again with column headings.
Search WWH ::




Custom Search