1. Get the excel Sheet .

2. Save it in ?file_name. CSV? format.

3. Make a copy from this CSV file and rename it to a ? File_name.txt? format.

4. Create a table in the Oracle database that its columns map the fields of the Excel sheet.

5. Create a control file that read the data from the file generated from step 3 and put the data in the oracle Table generated in step 4.

6. From the command prompt, run the SQL Loader that run the CTL file and perform the task of copying the data from the Excel into Oracle.

C:\sqlldr username/password file.ctl path

E.g.: c:\sqlldr bplus/bplus c:\xyz.ctl

-----

here is the content of the control file
the controlfile contas the strucur of the table.

LOAD DATA
INFILE "C:\sqlldr\hano_gard\HANO1.txt"
INTO TABLE table_name

FIELDS TERMINATED BY ';'