Thanks for the question, VC.
Asked: November 16, 2024 - 5:35 pm UTC
Last updated: December 04, 2024 - 5:57 am UTC
Version: Oracle 12c
Viewed 1000+ times
You Asked
I have a requirement to load a large excel file (upto 2000 columns) into Oracle database. I am aware of Oracle table limitation of maximum 1000 columns per table and happy to split the data into multiple tables.Could you please help.
and Connor said...
APEX can load an excel file easily into the database (still with the limit of 1000 cols). So I would
a) If necessary, add a column that can serve as a primary link between the "n" tables you will create. Let's assume its column "A" (eg you could populate it with an ascending number in Excel)
n) Split the workbook into 1000 column chunks, eg
file 1: columns A,B,C,D...
file 2: columns A, CD, CE, CF, ...
Notice you keep column in A in each so that you can associate the rows once loaded.
Then use the APEX load-from-sheet option and you're done.