Oracle Forms

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!

map excel columns on oracle forms and insert it into database

sam8682Apr 11 2013 — edited Apr 24 2013

Hello,

I have task. I am using oracle forms 6i. I want to import excel data to oracle forms(its common task using ole2 package). But this time I want to map the columns i.e my database table having 5 columns. and the excel file is having 2 or 3 columns then i suppose to map those columns and accordingly insert it to my table.
So far i have import column heading of excel to oracle forms, then i've provide list item for mapping each column
so that user can map excel column to database columns. Now I am confuse how to write the code so that selected columns should get inserted into database.

somebody please help me for the same.

Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 22 2013

Added on Apr 11 2013

#form, #forms, #moved-from-devops

16 comments

3,435 views