# How to Convert Excel to Microsoft Access

> 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.

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

## Steps

1. Click 'External Data' on the ribbon.
2. Select 'New Data Source' .
3. Click 'From File' and select 'Excel'.
4. Browse for the Excel file you want to import and click 'Browse'.
5. Choose how to store the data.
6. Click 'OK'.
7. Select the sheet or range that contains the data.
8. Click 'Next'.
9. Review and adjust the fields such as set data types and rename columns.
10. Click 'Next'.
11. Select a primary key.
12. Click 'Next' to proceed.
13. Provide a name for the imported table.
14. Review the summary and click 'Finish'.
15. Open the new table in Access to ensure the data is correctly imported.
