Load excel data into oracle database

1. How to load excel data into oracle database by using sql loader?
2. What are the ways to load data from excel file in oracle database ?

Showing Answers 1 - 6 of 6 Answers


  • May 16th, 2015

by using inbound interfaces we can upload excel data into oracle base table
first we develop the control file
By the control file we can convert the data from excel format to stage table data
By the procedure we can convert data from the stage table to interface table
here we can check validations
now we have to register the procedure as concurrent program
then we execute by srs window now the total data base is converted from interface table to oracle base table.

  Was this answer useful?  Yes


  • Sep 4th, 2015

Load data
Infile a.xls
Into table table_name
Fields terminated by ,
(Id ,name,job,city);

You can directly import data by using SQL developer as well.

  Was this answer useful?  Yes


  • Sep 20th, 2015

A correction , you cannot load excel but CSV/TXT files by this method

  Was this answer useful?  Yes

Prashant Sahare

  • Oct 15th, 2015

Dear All, Help of Sql developer you can import file in oracle database just create a table architecter similar of excel (with column name) and import..
And Remeber "SET DEFINE OFF;" on work Sheet before import;

  Was this answer useful?  Yes


  • Nov 13th, 2015

Best and most easy way is to use an external table. Keep the file in designated location and file will automatically loaded into table every time you put a new file or update the file. Create trigger on the given table to load the data into respective tables.

  Was this answer useful?  Yes

Naresh Bandla

  • Dec 1st, 2015

You can upload the Excel file into tables by many approaches, I will explain here in two methods.

1. Loading data using Loader programs:
Convert your excel file into CSV file and create control as per your requirement and register it as Loader Program. Run that program it will load the data into tables.

2. Using Developer tools(TOAD):
By using TOAD also we can upload the data into respect tables.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions