3 Replies Latest reply: Jun 20, 2014 10:58 AM by Mike Kutz RSS

    What is the best way to load 200+ fields from a spreadsheet into multiple tables?


      I have a need to take a large spreadsheet (that the user will provide via a data entry screen's file browser) and use the 200+ fields to create records in various tables. Any suggestions for the best way to accomplish this using just Oracle APEX 4.2 or PL/SQL or any other tools that come standard with Oracle 11g? Note: I cannot use any 3rd party applications or plug-ins. Thanks in advance for your help!