XlsToOra - Oracle import Excel »

Download XlsToOra Free Trial »     Buy XlsToOra Now »

How to batch import Excel data to Oracle from a folder

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

Batch import Excel data To Oracle - task window

then show the import wizard.

1. Select a folder.

Batch import Excel data To Oracle - select a folder

2. Select a table and config fields.

Import data from Excel to Oracle - select table

3. Preview data.

Batch import Excel data To Oracle - preview

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

Import data from Excel to Oracle -  import data