Skip to Main Content
Forums

APEX

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!

Upload multiple excel files into tables using APEX

Graham BanksOct 1 2008 — edited Oct 8 2008
Hi folks,
I'm wondering if anyone has ever uploaded multiple .csv files simultaniously and store the data into the database using APEX XE before.
I can browse for a single file, and execute that okay and a good example of doing that can be found at http://advait.wordpress.com/2008/05/21/uploading-excel-sheet-using-oracle-application-express-apex/
This works fine when the user browses to a specific file on their network and then uploads the data from that one file.
However I need the ability to 'grab' every file in a specific directory one after the other to process rather than having to specify which one to load everytime, and wondered if anyone has come across this before.

Many thanks

Graham.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 5 2008
Added on Oct 1 2008
#apex-discussions, #excel, #load, #text, #xe
8 comments
1,034 views