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".
Mock data kindly provided by Mockaroo.
