How to Import Excel Data into Microsoft Access Database

Quick summary

Importing Excel data into Microsoft Access lets you convert spreadsheet records into a structured, queryable database table. This step-by-step process uses the built-in Import Wizard to map columns, set field names, assign a primary key, and save the data as a new Access table.

Steps

1. Go to the External Data tab in Access.
2. In the Import & Link group, click New Data Source.
3. From the drop-down menu, select From File and click the Excel option.
4. Click Browse to locate and select your Excel file.
5. Choose how you want to import your data and select the appropriate option.
6. Click OK to proceed.
7. Check the box if the first row in Excel contains field names.
8. Click Next to continue.
9. Review the field name and data type, then click Next.
10. Assign a primary key and choose the option that fits your data requirements.
11. Click Next to proceed.
12. Enter a name for the new table.
13. Click Finish to complete the import.