Export data from excel spreadsheet to an Oracle Table

[Kurtz]

How could I fetch data in from an Excel spread sheet into an oracle table? Any examples appreciated...!

[Raine]

Open the worksheet you need to export to oracle & save it in csv format and In oracle write a control file to load data into Oracle using sqlloader.

Hope This Helps You...!

[JonathanD]

Try this code & if any error occur post Back here...!

export ORACLE_HOME=/u01/app/oracle/product/9.2.0
export PATH=$PATH:$ORACLE_HOME/bin
sqlldr userid=mag/mag control=member.ctl bad=member.bad
if test -s member.bad
then
mailx -s 'errors in sqlLoad.following records are rejected' client@client.com < member.bad
fi
touch member.bad
rm member.bad

This is control file used by sqlloader

load data
infile 'member.dat'
replace into table member
fields terminated by ',' trailing nullcols
(name, address)