Home » Developer & Programmer » Forms » import data from excel and process via oracle forms 10g (oracle 10g r2 office 03/ 07)
import data from excel and process via oracle forms 10g [message #364349] Mon, 08 December 2008 02:21 Go to next message
DRASTANT
Messages: 21
Registered: July 2007
Location: KENYA
Junior Member
hi all

I am trying to desing a form which will take excel file as input and import that data to a oracle table and then to qurey that table joining other existing tables and to generate an output.

can anyone explain

thanks
drastant
Re: import data from excel and process via oracle forms 10g [message #364526 is a reply to message #364349] Tue, 09 December 2008 00:16 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Search this forum for 'excel' there are MANY threads on this topic.

David
Re: import data from excel and process via oracle forms 10g [message #365247 is a reply to message #364526] Thu, 11 December 2008 04:03 Go to previous messageGo to next message
DRASTANT
Messages: 21
Registered: July 2007
Location: KENYA
Junior Member
THANKS
LOOKED INTO THE FORUM AS PER YOUR INSTRUCTION I FOUND QUITE A FEW BUT NONE OF THEM ARE CLEAR.

CAN ANYONE ASSIST.

THANKS
DRSTANT
Re: import data from excel and process via oracle forms 10g [message #366194 is a reply to message #365247] Fri, 12 December 2008 01:31 Go to previous messageGo to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
I am also facing the same problem.
Re: import data from excel and process via oracle forms 10g [message #366201 is a reply to message #364349] Fri, 12 December 2008 02:13 Go to previous messageGo to next message
sirivijay
Messages: 48
Registered: October 2008
Member
I also had a similar issue but i have to browse a file with .out extension in local machine and to export its content to the databasenot knowing how to use sql loader for this..sitting on this issue from many days..
Re: import data from excel and process via oracle forms 10g [message #375818 is a reply to message #366201] Mon, 15 December 2008 00:48 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Here they are again:
Working with Excel via OLE2
http://www.orafaq.com/forum/t/72811/67467/
http://www.orafaq.com/forum/m/84230/67467/
http://www.orafaq.com/forum/t/101906/67467/
Merge two cells in Excel using ole2
http://www.orafaq.com/forum/t/77825/67467/
Error closing Excel file generated using OLE2
http://www.orafaq.com/forum/t/77351/67467/
How to wrap text in excel cell using ole2
http://forums.oracle.com/forums/thread.jspa;jsessionid=8d92200830d62336f40f5aad44efb36ee981f4e6c19e.e34QbhuKaxmMai0MaNeMb3eKb390?mess ageID=1242535&#1242535
Excel via DDE
http://www.orafaq.com/forum/m/260061/67467/#msg_260061
Import from Excel
http://www.orafaq.com/forum/mv/msg/32353/86299/67467/#msg_86299
Forms to Excel example with webutil
http://forums.oracle.com/forums/thread.jspa?messageID=1430799
Another Forms to Excel example
http://www.orafaq.com/forum/t/81537/67467/
How to kill EXCEL.exe from Task Manager from Oracle Forms
http://www.orafaq.com/forum/t/88643/67467/
how do i display all excel worksheets name in form
http://www.orafaq.com/forum/t/89775/67467/
More Excel stuff
http://www.orafaq.com/forum/t/90502/67467/
To run an excel macro
http://www.orafaq.com/forum/t/47685/67467/
Worked example for using Excel through ODBC
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4406709207206#18830681837358
create excel chart in form6I/How to SetSourceData into excel.chart in form6i
http://www.orafaq.com/forum/t/99738/67467/
Call Excel file from Forms
http://www.orafaq.com/forum/t/121433/67467/

David
Previous Topic: FRM-41042: Cannot create Group REC - Error
Next Topic: Get all parameter from a parameter list
Goto Forum:
  


Current Time: Sat May 04 08:19:15 CDT 2024