Import rows via XLS or CSV file
569964Apr 25 2007 — edited Apr 30 2007Hello everyone
I'm back on the job with APEX now :)
Run into a little snag...
We need to import data into an existing table from inside an application using an Excel file.
eg. there might be a page with a table report, and a file browser.
You can select an excel file, and it will add all records from that file into the table in the database.
Does APEX have any ways to do this sort of thing?
It can do it from inside the APEX Utilities -> Data Load/Unload -> Load page.
But I need to be able to do it from inside an application.
Many thanks!!
Sam