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.

  1. Click | Start | Programs | MS Access
  2. Select Open a new "blank database" | Click the Create button
  3. From the menu items select File | Get External Data | Import
  4. Choose the correct location of your spreasheet file and file type so that your file will appear in the import dialog
  5. Single click on your spreadsheet's icon and select the Import button in the dialog
  6. Check the check box if your spreadsheet's first row contains column headings (labels) | Click Next
  7. Select the In New Table radio button | Click Next
  8. You may now modify field properties or | Click Next
  9. Select Let Access Choose the Primary Key | Click Next
  10. 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