Home Import Oracle data from text file

Import Oracle data from text file

1. Click Load button.

oracle load button

then show the Load form.

oracle load form

2. Select data file.

You can select csv file, txt file. If you want to load Excel data to Oracle, save Excel data to csv file, then uses OraLoader import it.

After selected data file, OraLoader will auto set load parameters (FieldCount, Filename in file header, Have multi-line field, Delimiter, Quoted By).

oracle load data file

3. Select table.

After selected table, OraLoader will auto set loading relative fields.

oracle load table

4. Config fields.

You can set loading parameter and fields manually.

oracle load fields

5. Load or Save to sql.

oracle load sql
top of page