Oracle APEX load more than 45 columns

Question

I am using Oracle APEX 5.1.3 and tried to create a Data Load Wizard where a user submits a CSV with 67 columns but ran into the problem where there is a 45 column limit for the Data Load Wizard. Is there a way around this?

Answer 1

Yes, APEX 5.1.3 has this limit. There are however work arounds using external table or loading the table and writing your own post-process.

Import data in excel to database table

Upload data from csv to table in APEX