Batch import Excel files data to Access

How to batch import Excel data to Access from a folder

Click "Wizard - N Files To 1 Table" at task dialog.

Batch import Excel data To Access - task window

then show the import wizard.

1. Select a folder.

Batch import Excel data To Access - select a folder

2. Select a table and config fields.

Import data from Excel to Access - select table

3. Preview data.

Batch import Excel data To Access - preview

4. Import to table or save sql script to file.

Import data from Excel to Access - import data