OraFAQ Forum: Forms » data to Excel & copy a file

Home » Developer & Programmer » Forms » data to Excel & copy a file

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

data to Excel & copy a file [message #217615]

Sat, 03 February 2007 02:58

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

Report message to a moderator

Re: data to Excel & copy a file [message #217645 is a reply to message #217615]

Sat, 03 February 2007 22:59

Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA

Senior Member

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4892427289280

Report message to a moderator

Re: data to Excel & copy a file [message #217702 is a reply to message #217615]

Sun, 04 February 2007 23:09

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Search this forum for "HOST" and "EXCEL"

Report message to a moderator

Re: data to Excel & copy a file [message #217951 is a reply to message #217702]

Tue, 06 February 2007 03:30

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 14:30:59 CDT 2024