Options For Loading Excel Data Into APEX Applications

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:

  • Ability to load vanilla Excel files or those first converted to csv
  • Options for manual loading or automation
  • Tools that can be used ad-hoc or options for scheduling
  • Solutions more appropriate for smaller files or high performing tools for high volumes

Facebook
Google+
http://www.explorer.uk.com/options-loading-excel-data-apex-applications">
Twitter
LinkedIn

Follow us on twitter

@Explorerukltd

About the Author

Philip Ratcliffe

Oracle APEX Development Consultant

Explorer (UK) Ltd - Oracle award winning Platinum Partner and UKOUG Database Partner of the year 2015 & 2016

Philip is a Development Consultant at 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.

APEX, Blog, TECH17, Why use APEX / APEX, Excel

Featured Posts