OraFAQ Forum: Forms » using forms 6i :map the excel columns and insert it in oracle table

Home » Developer & Programmer » Forms » using forms 6i :map the excel columns and insert it in oracle table (oracle forms 6i)

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

using forms 6i :map the excel columns and insert it in oracle table [message #584720]

Fri, 17 May 2013 02:12

sameer_da
Messages: 74
Registered: April 2013
Location: India

Member

Using oracle forms 6i i want to carray out following task.
suppose i've table with following fields
ROUTE_ID, TRN_DATE,TRN_TIME,TRN_ID
and i've excel sheet with following details

date		 rid			time				tid
----------------------------------------------------------------------------------
20-03-13         route1		        20:30:45		        RDT-01
25-03-13         route2		        15:25:30		        RTD-02
26-03-13         route3		        10:15:20		        RTD-03

i want to import this excel data to my oracle table by column mapping
i.e ROUTE_ID in my table is in first place but in excel sheet it is in second place,
TRN_DATE in my table is in second place but in excel sheet it is in first place.
next time i may get excel sheet which will be like this

tid			rid			date				time
---------------------------------------------------------------------------------------------
RTD-01	                route1                  20-03-13		        20:30:45
RTD-03	                route2		        25-03-13		        15:25:30

This excel sheet also have different oreder than my database table and i want to import it to my database table using forms 6i.
Somebody please help me to solve this problem. PLEASE ITS URGENT Sad

Report message to a moderator

Previous Topic:	How to Insert and Update from Global temporary table ??
Next Topic:	slide-show

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 10:49:54 CDT 2024