Import data from an Excel spreadsheet into Access

1. In MS Access,from the FILE menu, pick NEW DATABASE
   
   
2. Choose blank database if prompted.
   
   
3. To import a spreadsheet, on the FILE menu, point to GET EXTERNAL DATA and choose IMPORT.
   
   
4. In the Import (or Link) dialog box, in the Files Of Type box, select Microsoft Excel (*.xls).
   
   
5. Click the arrow to the right of the Look In box, select the drive and folder where the spreadsheet file is located, and then double-click its icon.
   
   
6. From the Import Spreadsheet Wizard Dialog box click on "First Row Contains Column Headings", hit "next".
   
   
7. When prompted for where you want the spreadsheet choose "In a New Table", hit "next".
   
   
8. Access will ask if you want to index on the field "site_id" (the answer is yes) so hit "next".
   
   
9. Let Access choose the primary key, hit "next".
   
   
10. Click "Finish".
    
    
11. Follow steps 2 through 9 for the remaining tables.

For additional help go to Microsoft Support