Import data from Excel To SQL Server - 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 SQL Server - save session file

2. Load session.

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

Excel To SQL Server - load session button

then start the saved session.

Source

Import Excel data To SQL Server - select a file

Target

Import data from file To SQL Server - select table

Preview

Import Excel data To SQL Server - preview

Import to table

Import data from file To SQL Server - import data