# How to Import Excel Data into Microsoft Access Database

> To import Excel data into Microsoft Access, go to the External Data tab, select New Data Source, choose Excel from the file menu, and browse for your file. Select your import options, configure field names, set a primary key, name the new table, and click Finish.

Canonical: https://livedemo.ai/tutorials/how-to-import-excel-data-into-microsoft-access-database/
Apps: Microsoft, Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3fb3ab56e05a00fe7b61/preview?step=1

## 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 on the 'Excel' option.
4. Click 'Browse' to locate and select your Excel file.
5. Choose and select how you want to import your data.
6. Click 'OK' to proceed.
7. Check this box if the first row in Excel contains field names.
8. Click 'Next'.
9. Review the field name and data type. Click 'Next'.
10. Make sure to assign a primary key and choose the option that fits your data requirements.
11. Click 'Next'.
12. Enter a name for the new table.
13. Click 'Finish'.