Skip to Main Content
Forums

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!

How to import excel file having multiple sheets and create one table per sheet

User_HBVVYJul 6 2022

I have an excel file with 500+ worksheets and each sheet has a table. I want to import the excel file so that a table is created for each sheet resulting in 500+ tables in the database filled with 500+ sheets' data. I want to know if there is a way to do this all at once as I don't want to manually import 500+ sheets and create their tables one by one.

Comments

Post Details

Added on Jul 6 2022
#database, #excel, #import, #multiple, #oracle
3 comments
2,048 views
1 mention