Skip to Main Content

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!

Open an Excel file to read and load it into Oracle - Oracle COM Automation

user11326095May 7 2011 — edited Dec 28 2012
Hello All,

Please I need your help for this problem:

I need to load Excel sheet data (read the data) and load it into Oracle database (insert into a table), the excel file created and has data before, and saved with xls format. and I need to do that using the Oracle® COM Automation (ordcom package). The examples I found open and create a new workbook and deletes the old saved data, so I need to open (edit) the sheet just for reading.

I appreciate ans sample code to help me do that, Please help me out. This is very urgent.

Thanks alot and best regards,

Nabil
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 25 2013
Added on May 7 2011
19 comments
17,800 views