Home » Developer & Programmer » Forms » data to Excel & copy a file
data to Excel & copy a file [message #217615] Sat, 03 February 2007 02:58 Go to next message
jineshtr
Messages: 1
Registered: February 2007
Location: Dubai
Junior Member
Dear friends,


I am using forms 6i and 10g Database.
I want populate Excel with some of my records
eg.
SELECT EmpName,EmpCode FROm EmpMaster

When I click on a button, Excel should populate with these out put ? how it is posible ? anybody can help me with its codes ?

Same time I wasnt to copy a file from one place to another folder, pls give me its coding.

Jinu
Re: data to Excel & copy a file [message #217645 is a reply to message #217615] Sat, 03 February 2007 22:59 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8623
Registered: November 2002
Location: California, USA
Senior Member
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4892427289280
Re: data to Excel & copy a file [message #217702 is a reply to message #217615] Sun, 04 February 2007 23:09 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Search this forum for "HOST" and "EXCEL"
Re: data to Excel & copy a file [message #217951 is a reply to message #217702] Tue, 06 February 2007 03:30 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
See:
Worked example for using Excel through ODBC
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4406709207206#18830681837358

Working with Excel via OLE2
http://www.orafaq.com/forum/t/72811/67467/

David
Previous Topic: I NEED HELP URGENT
Next Topic: HIDE_WINDOW('WIN') by text_item trigger
Goto Forum:
  


Current Time: Sat Dec 03 11:56:52 CST 2016

Total time taken to generate the page: 0.07812 seconds