The most common APEX data load problem….how to load MS Excel files as XLS, not as CSV.
There are as many ways to load data into an Oracle database as … well, there are a lot of them. When building an Oracle Application Express application, there are some data load options that are more suitable than others. This presentation outlines the standard APEX-supplied data load options, explores the APEX Data Load wizard, and discuss how to integrate some more traditional Oracle data load options into your APEX applications. This is by no means an inclusive view of all the possibilities, but some of these options will give you ideas on how best to approach your data load issues.
Download the presentation here: APEX Data Loading Options