Importing an Excel
Spreadsheet into Access
This example assumes that you have an
Excel spreadsheet file saved on disk that you would like to import into
a new database.
-
Click | Start | Programs | MS Access
-
Select Open a new "blank database" | Click
the Create button
-
From the menu items select File | Get External
Data | Import
-
Choose the correct location of your spreasheet
file and file type so that your file will appear in the import dialog
-
Single click on your spreadsheet's icon and
select the Import button in the dialog
-
Check the check box if your spreadsheet's
first row contains column headings (labels) | Click Next
-
Select the In New Table radio button | Click
Next
-
You may now modify field properties or |
Click Next
-
Select Let Access Choose the Primary Key
| Click Next
-
Title your new Table | Click the Finish button.
You have now imported your spreadsheet data
into a new table in Access. You many now create other objects in this database
as needed.
Back
to Tom's Site
LastUpdated 7/1/2001
Copyright 2001 T.C.
Spencer