OraFAQ Forum: Forms » import excel by column mapping using oracle 6i form

Home » Developer & Programmer » Forms » import excel by column mapping using oracle 6i form (oracle forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

Re: import excel by column mapping using oracle 6i form [message #585442 is a reply to message #585411]

Sat, 25 May 2013 10:43

na.vaithianathan
Messages: 6
Registered: November 2007

Junior Member

first check the max.size of the column and it's data type.
otherwise load it in a new table. Then covert it to your table.
if for further help
pl. send the fmb & excel (2003 or 2007)

Report message to a moderator

Re: import excel by column mapping using oracle 6i form [message #585505 is a reply to message #585411]

Mon, 27 May 2013 00:08

sameer_da
Messages: 74
Registered: April 2013
Location: India

Member

Thank for reply na.vaithianathan,
Please find the attachment of form, table script and excel file.
I am sorry i am using excel 2000

create table test
(ROUTE VARCHAR2(100),
TRNDATE VARCHAR2(100),
TTIME VARCHAR2(100),
TID VARCHAR2(100));