Batch import CSV(TXT) to Oracle

How to batch import txt (csv) data to Oracle from a folder

Click "Load From Files (Folder)" at task dialog.

Batch import Csv (Txt) data To Oracle - task window

then show the wizard.

1. Select File Type.

Import Data From Csv (Txt) To Oracle - select file type

2. Select a folder.

Batch import Csv (Txt) data To Oracle - select a folder

3. Select a table and config fields.

Batch import Csv (Txt) data To Oracle - select table

4. Preview data.

Batch import Csv (Txt) data To Oracle - preview

5. Import.

Batch import Csv (Txt) data To Oracle - import data

For repeatable task, you can click "Save Session" button to save config, then run it next time. see also: Save and load session.