SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Load excel files with multiple sheets to table

587126Jun 18 2020 — edited Jun 18 2020

Hi,

We have excel file with multiple sheets (around 100), all sheets have same structure. Data in all the sheets have to be loaded to a table.Sheet name should also be loaded to table.

If it was only one sheet, I could have saved as .csv file and load using sql loader or use Import functionality in sql developers.

Oracle version : 12.2

Could you please advise any solution.

Thanks

Added on Jun 18 2020

7 comments

4,760 views