balaji

• 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.

Sravanthi

• 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.

Shobhit

• Sep 20th, 2015

 

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

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;

ashay

• 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.

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.