How to Import Excel Data into Microsoft Access Database
- George Apostolov
How to Import Excel Data into Microsoft Access Database: step-by-step guide
Go to the 'External Data' tab in Access.
In the 'Import & Link' group, click 'New Data Source'.
From the drop-down menu, select 'From File' and click on the 'Excel' option.
Click 'Browse' to locate and select your Excel file.
Choose and select how you want to import your data.
Click 'OK' to proceed.
Check this box if the first row in Excel contains field names.
Click 'Next'.
Review the field name and data type. Click 'Next'.
Make sure to assign a primary key and choose the option that fits your data requirements.
Click 'Next'.
Enter a name for the new table.
Click 'Finish'.
Quick answer: 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.
About this Microsoft tutorial
Easily bring Microsoft Excel spreadsheets into Access by browsing for files, configuring fields, setting primary keys, and naming tables. This guide shows how to import Excel Data into Microsoft Access Database in 13 steps, starting with "Go to the 'External Data' tab in Access" and finishing with "Click 'Finish'". The interactive demo above is a click-through copy of the real Microsoft interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to import Excel Data into Microsoft Access Database?
13 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Microsoft data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Microsoft and Excel. Related guides: How to indent in microsoft excel, How to Insert a Chart in Microsoft Excel and How to Insert a Degree Symbol in Microsoft Excel for Mac. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
