Skip to Main Content
  • Questions

  • Loading a large excel file (upto 2000 columns) into Oracle Database

Breadcrumb

XMAS_TREE

The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.

Question and Answer

Connor McDonald

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.



We're not taking comments currently, so please try again later if you want to add a comment.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.