Skip to Main Content
  • Questions

  • Load Excel with Multiple tabs or Multiple sheets into Oracle Table

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Shah.

Asked: January 21, 2016 - 6:50 am UTC

Last updated: January 21, 2016 - 10:51 am UTC

Version: 11g

Viewed 10K+ times! This question is

You Asked

Hi,

First of all Kudos to all the efforts and contribution that has made this site 'The Site' for many developers.

;)

My Issue is below ;

I have an Excel file in the server which has multiple sheets within it and each sheet corresponds to a certain table.

The task is to load each of the Sheet of this single EXCEL File into the respective Oracle Tables.

Could you let me know how this can be achieved ?

Thank you in advance,
Shah.

and Chris said...

Anton Scheffer has written a package to read XLSX files from the database server:

https://technology.amis.nl/2013/01/19/read-a-excel-xlsx-with-plsql/

This enables you to return the contents as a table. The sheet name is one of the columns. So you can use SQL to query it as you want.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Great Work (Anton)!!

Shah, January 24, 2016 - 7:12 am UTC

The solution from Anton has sorted out my issue.
Thanks!!
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 latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library