Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Importing and Exporting Data
sure it looks right before you paste it into the permanent datasheet.
Another option is to append the table containing the new data to the
existing table. Append queries, which do that job, are covered in Book
III, Chapter 3.
✦ If you choose not to use the Paste Append command or an append
query, you have to select multiple cells (fields, records, or both) if
you want to paste content into multiple cells. You don’t have to select
the exact number of cells that you’re copying into. If you don’t want
to count the exact number of rows or columns that you want to copy
data into, just select more than you think the data will fill. To make new
records, click the New Record button. You may need to put a piece of
data in each record. The dummy data will be overwritten when you copy
data into the records.
✦ One easy way to select cells in a worksheet is to click the first cell (in
the top-left corner of the range) and then Shift+click the last cell (in the
bottom-right corner of the range).
✦ You can’t copy into subdatasheets as you copy into the main datasheet.
Copy into one table at a time.
Moving data from Excel to Access
Do you want to copy and paste a relatively small amount of data from Excel
to Access? If so, these steps are a very convenient way to copy and paste
into a brand-new Access table:
1. In Access, open the database to which you want to copy the data.
2. In Excel, open the workbook, and display the worksheet that contains
Make sure that the first row of data makes adequate field names. (You
can always change them later.)
3. Select the data in Excel, and press Ctrl+C to copy the data to the
4. Click any table in the Access Navigation Pane, and press Ctrl+V to
paste the data into a new table.
5. When Access asks whether the first row of your data contains column
headings, click the Yes button.
Access creates a new table from the Excel data, giving that table the
same name as the Excel worksheet that contained the data. You may
need to rename your table, but wasn’t that easy?
Alternatively, you can open a new or existing table, arrange your windows so
that you can see both the data in Excel and the table where you want to put
the data, and then drag the data from Excel to Access.