Loading excel data into Oracle table - automated

To discuss Oracle Forms & Reports related technical issues.
Post Reply
Sidhant
Posts: 1
Joined: Thu Mar 22, 2007 4:36 am
Location: India

Loading excel data into Oracle table - automated

Post by Sidhant »

Dear All and Sikander..
i want to build an utility to load excel data in a pre-defined format to oracle table.
Don't want to save it as .csv and use sqlldr..
It should be done thru a click of Button
I think OLE automation can help..
can anyone please help me out with a definite solution, how to code the stuff..

thnx in advance,
iftikhar
Posts: 6
Joined: Wed Apr 04, 2007 8:51 am
Location: Pakistan

Post by iftikhar »

Dear,
You can do this by SQL loader with CSV file. it s simpl procedure.
send me CSV file i'll send you fmb with single click ok
Post Reply

Who is online

Users browsing this forum: No registered users and 12 guests