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!

Import data from excel (multiple sheets) into oracle table - Automation of the process

Bhavin MamtoraMay 30 2014 — edited May 30 2014

Hello ,

I need help in importing data into an oracle table from an excel sheet.

I have an excel file which has 30 worksheets with data in the same location in all the sheets .

Requirement is to automate the process of data import into an oracle table.

I tried to manually copy all the data into one sheet and upload it using sql loader but this is very tedious and time consuming.

Let me know if there is a possibilty or alternative to make this process quick and simple.

Database version : Oracle Version: 11.2.0.3

Thanks,

Bhavin

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 27 2014

Added on May 30 2014

3 comments

2,267 views