How could I fetch data in from an Excel spread sheet into an oracle table? Any examples appreciated...!
How could I fetch data in from an Excel spread sheet into an oracle table? Any examples appreciated...!
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...!
Try this code & if any error occur post Back here...!
This is control file used by sqlloaderexport 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
load data
infile 'member.dat'
replace into table member
fields terminated by ',' trailing nullcols
(name, address)
Bookmarks