How to Convert Excel to Microsoft Access
- George Apostolov
This guide is an interactive LiveDemo. Create interactive demos of your own product: Interactive demo software · Interactive customer onboarding guides · Start free
How to Convert Excel to Microsoft Access: step-by-step guide
Click 'External Data' on the ribbon.
Select 'New Data Source'.
Click 'From File' and select 'Excel'.
Browse for the Excel file you want to import and click 'Browse'.
Choose how to store the data.
Click 'OK'.
Select the sheet or range that contains the data.
Click 'Next'.
Review and adjust the fields such as set data types and rename columns.
Click 'Next'.
Select a primary key.
Click 'Next' to proceed.
Provide a name for the imported table.
Review the summary and click 'Finish'.
Open the new table in Access to ensure the data is correctly imported.
Quick answer: To convert Excel to Microsoft Access, click External Data on the ribbon, select New Data Source, and choose From File then Excel. Browse for the file, choose storage options, select the sheet, review and adjust fields, set a primary key, name the table, and finish the import.
About this Microsoft tutorial
Import Excel data into Microsoft Access by selecting External Data, choosing your file, adjusting fields, setting a primary key, and finishing. This guide shows how to convert Excel to Microsoft Access in 15 steps, starting with "Click 'External Data' on the ribbon" and finishing with "Open the new table in Access to ensure the data is correctly imported". 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 convert Excel to Microsoft Access?
15 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 Copy a Plan in Microsoft Planner, How to Copy and Paste Cell Content in Microsoft Excel and How to copy conditional formatting microsoft excel. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today





