How to batch import data to Oracle from a folder

OraLoader can import data to Oracle from JSON, XML, CSV, TSV, TXT, RDF, Excel, HTML, SQL, INI, and more.

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

Batch import Files data To Oracle - task window

then show the wizard.

1. Select File Type.

Import Data From Files To Oracle - select file type

2. Select a folder.

Batch import Files data To Oracle - select a folder

3. Select a table and config fields.

Batch import Files data To Oracle - select table

4. Preview data.

Batch import Files data To Oracle - preview

5. Import CSV(TXT) to Oracle.

Batch import Files 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.