Microsoft Access 2003

1
Microsoft Access 2003

• Transferring an Excel Worksheet into an Access
  Database

2
Open the Import Wizard

• With the database open, right-click in the
  database view
• Click Import

3
Select the Excel Workbook to Import

• In the Import window, click the Files of type box
  arrow and then click Microsoft Excel
• Select the workbook, then click on the Import
  button

4
Select the Worksheet to Import

• Make sure Show Worksheets is selected
• Select the worksheet you want imported and press
  the Next button

5
First Row Contains Column Headings

• If the first row of your spreadsheet contains
  field names, then check the First Row Contains
  Column Headings
• Press the Next button

6
In a New Table

• Select In a New Table and click the Next button

7
Data Types for the Fields

• In this step of the wizard, different data types
  can be selected for each field
• This does not need to be changed
• Press the Next button

8
Choose the Primary Key

• In this step, you can choose which field is the
  primary key
• Usually you select Choose my own primary key
• Click on the field to the right and select the
  field you want as the primary key
• Click the Finish button

9
There is Your New Table

• There is your new table