Importing Excel spreadsheets into Access

Open Microsoft Access

Create a new database

Blank Access Database (click OK)

File New Database dialog: save with filename, e.g. Stampit boots.mdb

Database appears, ready to go...

Import the table

File > Get external data > Import

Change file of type to: Microsoft Excel (*.xls)

locate Excel .xls file

Click: Import


Import Spreadsheet Wizard appears: (there should be little to do other than click 'Next')

Show worksheets appears - ensure sheet 1 is selected and you can see the data

Click 'Next'

First row contains column headings - ensure checked

Click 'Next'

Where would you like to store your data: In a New Table

Click 'Next'

Another dialog about fields...

Click 'Next'

Primary key dialog - allow Access to add primary key

Click 'Next'

Name for table "DMboots"

Click 'Next'

Click OK

Double-click on DMboots table to look at it

Back

Back to IT Principles Home