I was wondering if there's any workaround for uploading data into the tables using the apex wizard when there are more than 45 columns. I am using Apex 5.0.4, Oracle 12 C database. I was going through the documentation where it lists that number of columns are limited to 45, when using the data load wizard. I could get it to work using the Data Workshop under SQL Workshop -> Utilities, but ideally it would be very helpful to have it on the application and let users upload data into the tables from spreadsheets.

I have tried looking at a few blogs and articles that talks about custom upload process from excel to tables using apex, however I am not convinced, doesn't seem to be completely feasible and flexible as they have certain limitations of the order of the columns in which they appear, data types, mapping.

https://avdeo.com/2008/05/21/uploading-excel-sheet-using-oracle-application-express-apex/

http://ittichaicham.com/2007/11/apex-to-upload-text-file-and-write-into/

Oracle Components Limit: https://docs.oracle.com/database/121/HTMDB/limits002.htm#HTMDB28632

Any suggestions are welcome.