Home » Developer & Programmer » Forms » using forms 6i :map the excel columns and insert it in oracle table (oracle forms 6i)
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
Previous Topic: How to Insert and Update from Global temporary table ??
Next Topic: slide-show
Goto Forum:
  


Current Time: Thu Oct 02 04:22:42 CDT 2014

Total time taken to generate the page: 0.07796 seconds