How to import txt (csv) data to Oracle

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

Run OraLoader, Click "Load From File" at task dialog.

Import Data From File To Oracle - task window

then show the wizard.

1. Select File Type.

Import Data From File To Oracle - select file type

2. Open a file.

Import Data From File To Oracle - open a file

3. Select a table and config fields.

Import Data From File To Oracle - select table

4. Preview data.

Import Data From File To Oracle - preview

5. Import CSV(TXT) to Oracle.

Import Data From File 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.