Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

loading data fro excell to a table

yair_kSep 16 2008 — edited Sep 17 2008
hey!
i'm trying to insert data from an excell file into a table.
i can do it through a form (using ole container), but i wish to do it from an outside procedure. i have search the related forums and find out that it can be done using java. this is no good solution for me!! i rather stick with pl/sql.
the complete task is to load data into a table ,from a number of xls files located in a given directory. i hope i could compleesh it with this proc.

any ideas?
thanks!!
yair
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 15 2008
Added on Sep 16 2008
5 comments
309 views