Import data from Excel To Access - Save/Load session to repeat task

Save/Load session

1. Save session.

when you click the "Save Session" button, show "Save Session" form, enter a session file name.

Excel To Access - save session file

2. Load session.

click the "Open a Saved Session" in task window, select a session file.

Excel To Access - load session button

then start the saved session.

Source

Import Excel data To Access - select a file

Target

Import data from file To Access - select table

Preview

Import Excel data To Access - preview

Import to table

Import data from file To Access - import data