Microsoft Access 2003 - PowerPoint PPT Presentation

1 / 9
About This Presentation
Title:

Microsoft Access 2003

Description:

Microsoft Access 2003 ... Transferring an Excel Worksheet into an Access Database ... an Excel Worksheet into an Access Database. Make sure Show Worksheets is ... – PowerPoint PPT presentation

Number of Views:160
Avg rating:3.0/5.0
Slides: 10
Provided by: jrjo
Category:

less

Transcript and Presenter's Notes

Title: 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
Write a Comment
User Comments (0)
About PowerShow.com