1 Open MS Access.
2 Create a blank database.
3 Set a database name and location and click on Create.
4 Go to "External Data" tab and click on "New Data Source" dropdown.
5 Choose "From File" and select "Excel".
6 Browse to your excel file, select "Import the source data into a new table in the current database." and hit OK.
7 Now check "First Row Contains Column Headings" and hit Next.
8 Specify your information about each of the fields you are importing and hit Next.
9 Now you can choose your primary key for this table and hit Next.
10 Choose a name for your table and hit Finish.
11 Go to "DesignView" and check out all imported fields.
12 That's it. Save and go back to "Datasheet View".