Microsoft Office Tutorials and References
In Depth Information
Importing data from Excel
Import data from Excel
6 If your spreadsheet includes column headings, select the First Row
Contains Column Headings check box, and click Next.
7 To change imported data types for a column, select the column.
Use the horizontal scroll bar to see more columns from the source
8 Select a data type in the Data Type drop-down box and click Next.
9 Allow Access to add a primary key, or choose a column to use as the
primary key. Click Next.
10 Type a name for the imported data table and click Finish.
TIP After you complete the import steps you will be prompted
with a screen to save the imported steps. This option allows you
to repeat the the saved operation, as described later in this section.