When creating a database, it’s fairly common that some of your data is already stored in a Excel spreadsheet. With a simple Import, you can quickly bring information stored in an Excel worksheet into an Access table.
And, the beauty of it is that Access has a wizard built for just such an occasion taking much of the work out of it for you.
Create a new table by importing or linking to external data
Open any database
Choose the Excel command in the Import group on the External Data tab
Figure 21. Import from Excel - Choose File Name & Import Type
3. Choose a File Name
4. Choose “Import the source data into a new table in the current database”
5. Click OK
Figure 22. Import from Excel - Choose Worksheet or Named Ranges
6. Choose “Show Worksheets” or “Show Names Ranges”
7. Click Next
Figure 23. Import from Excel - First Row Contains Column Headings?
8. If applicable, check “First Row Contains Column Headings”
9. Click Next
Figure 24. Import from Excel - Verify Field Data Types
10. Verify data type of each imported field
11. Click Next
Figure 25. Import from Excel - Choose a Primary Key
12. Choose a Primary Key option
13. Click Next
Figure 26. Import from Excel - Enter a Table Name
14. Enter a Table Name
15. Click Finish
Figure 27. Import from Excel - Save Import Steps?
16. Click Close