Excel is still widely used across many organisations as a standard reporting tool, often being used as a substitute for small databases. As a consequence, it has become necessary to load Excel data into APEX applications.
At the UK OUG TECH17 Conference, I introduced a number of options available to help import Excel data into APEX or the database tables underpinning your APEX applications.
The video attached is a recording of the presentation given at TECH17.
The options covered by the presentation and demonstration is not an exhaustive list, with other tools available. However, it introduces a combination of options that between them provide a variety of load capabilities, including:
Author: Philip Ratcliffe
Job Title: Oracle APEX Development Consultant
Bio: Philip is a Development Consultant at DSP-Explorer. Building on considerable experience in development including using Oracle PL/SQL and supporting Oracle EBS, Philip is employing APEX to provide quality, bespoke software solutions to a range of organisations.