|
This
sample spreadsheet has a Header Row. The Header Row contains all of
the data field names. This step lets you identify the
Column Headings.
5.
Try it: Use Column Headings for Field Names The
database is still open. The Import
Wizard is on step 3. Select:
First Row Contains Column Headings. What Do
You See? The first Row is now selected for the Field Names. Click
Next. Keep
going...
External Data ->Import & Link->Excel
Exam 77-885: Microsoft Access 2010
2. Building Tables
2.5. Import data from a single data
file: Import into a New Table |
|
| |
