Oracle Database Discussions

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!

excel upload from Java

DirdDec 21 2011 — edited Dec 21 2011

Hi guys,

I've been searching online today but have been unable to find a solution. Currently data is inserted from Java but is too slow. Is there a fast way to load it into tables with PL/SQL?
Problems:
- The file can't be .csv (the data contains commas)
- It should be inserted automatically (meaning HS cant be used?)

Users upload an excel file with data then it should go into the database. The file is stored on the server with the DB.

Thanks for any ideas.

Mike

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 18 2012

Added on Dec 21 2011

#excel, #from, #general-database-discussions, #insert, #java, #oracle, #table

1 comment

216 views