| import excel by column mapping using oracle 6i form [message #585411] |
Sat, 25 May 2013 01:43  |
 |
sameer_da
Messages: 74
Registered: April 2013
Location: India
|
Member |
|
|
hello,
I've done lot of search on different forms on this topic. i got answers as well but still my problem is not solved.
i am trying hard to complete this task. I am explaining in details what my requirement is, if anybody have solution please let me know.
"I want to imopert excel data by coloumn mapping to oracle table using forms 6i". for this I've created a form which is having following details.
1. path, file name text field and button called browse.
when the form load. click on browse botton, and user will be asked to go to specific drive and select the excel file. The file path is stored in path text field
and file name is displayed on file name text field.
2. After doing this I've porvide a button called column. after selecting the file click on column button. Once the button is pressed all column heading of
the selected excel file get displayed on the text fields which i've provide on the form.
3. In frot of each column headig field I've provide list box which contains database table column heading. Now user have to select table column according to his excel column.
(i.e I am asking user to map his excel column with oracle table column.)
4. Once the maping from user is done, I've provide button called process. once the button is pressed all the data from excel is to get insert in to database colmum.
what i've achive -
- User is able to select file path and file name get displayed.
- Columns heding of excel get displayed on the form.
problem area
-In the process button code column heading get change dynamically but records i.e actual data does not.
-I am able to insert records into table, but only when excel column heading sequence is same as database table column.
excel column = table column
-----------------------------------------------------------------
route = route
date = del_date
time = del_time
id = tran_id
In above situation record get insert into table.
But when only excel column sequence change that time data is not inserted into table.
If required i can uploade my form and sample excel sheet also provde table script.
Please give me solution for the same. I need it urgently. I am working hard on it.
Thanks and Regards
Sam.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
