Home » Developer & Programmer » Forms » import excel Data By column using oracle 6i form (Oracle6i Forms)
import excel Data By column using oracle 6i form [message #631741] Mon, 19 January 2015 06:00 Go to next message
musvag
Messages: 2
Registered: June 2014
Location: Kuwait
Junior Member
hello,
i have a table with data as mentioned below
ID Product Dicount
1 ABC 10
2 asd 20
3 axc 20
4 fff 30
5 rty 30
from my table i generate excel file. the excle data i need in my oracle 6i form by selecting excle path file
the all excle data should be in my oracle 6i form

please if someone can help

Thanks Regards

Please find the attached Sample File


  • Attachment: test.fmb
    (Size: 44.00KB, Downloaded 2199 times)
Re: import excel Data By column using oracle 6i form [message #631864 is a reply to message #631741] Wed, 21 January 2015 01:10 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

I can't understand your english
Re: import excel Data By column using oracle 6i form [message #631972 is a reply to message #631864] Thu, 22 January 2015 08:31 Go to previous message
CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
If I understand correctly, you want to import data into your database from an Excel spreadsheet using Oracle Forms to perform the import. Is this correct?

If so, there are numerous examples of how to do this using Oracle Forms' OLE methods in this forum as well as the Internet. Here are just couple:
http://www.orafaq.com/forum/t/129438/
https://sites.google.com/site/craigsoraclestuff/oracle-forms-webutil/read-excel-into-forms

Hope this helps,
Craig...
Previous Topic: Create folder in oracle app server 10g
Next Topic: How to change width of a column in Oracle Forms at run time
Goto Forum:
  


Current Time: Wed Apr 24 19:00:05 CDT 2024