OraFAQ Forum: Forms » send oracle table to excel

Home » Developer & Programmer » Forms » send oracle table to excel (forms 6i)

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

send oracle table to excel [message #439918]

Wed, 20 January 2010 02:40

yasser_egypt2000
Messages: 6
Registered: December 2009

Junior Member

Dear sirs,
i want to send oracle table to excel
and i used ole2 package, but i want to send all the table with fields name and header
pls anybody help me

thanks in Advance
Yasser

Report message to a moderator

Re: send oracle table to excel [message #440376 is a reply to message #439918]

Sat, 23 January 2010 00:55

tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka

Senior Member

see the following url:

http://tamzidul-amin.blogspot.com/2009/08/data-transfer-from-developeroracle-to.html

Report message to a moderator

Re: send oracle table to excel [message #440432 is a reply to message #439918]

Sun, 24 January 2010 15:36

shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan

Member

Hi Yasser,

I hope you are fine.

I have a solution for your problem.
you can do your needful by using (ODBC connection).
Follow the following steps and you will receive all the data with column headings in excel.

In excel.

click on data menu then click on Import External data sub menu.
after that click on import data.

Then you will find a dialog box opened on screen.

Click on the Push button Named "New Source..."
The data connection wizard will be started.
There will be a list of connection types.
Select Oracle from the list and click next.
then type the service name ,SID, Global Name in "server Name".
then type the username and password in the relevant fields.

I.E

Server Name : SMK
User Name : Scott
Password : tiger

then click next
you will find a list of all the tables.
select your desired table and then click next
choose the file name for you data source file. you can also save the password in the file.
Click finish.

you will see the first dialog box again and the open your file from this dialog box. then you will find the Last dialog box click on Ok and it is all done.

this is a log procedure to describe but you will feel it an easy way when you will use it.

if you want to do this on a client machine then you have to install the driver for Oracle database (relevant to version).

I hope this will solve your problem.

Regards

Muhammad Shahid Mughal
Oracle Developer
Professional's Corner (Software Development Department)
Faisalabad Pakistan

Report message to a moderator

Previous Topic:	Need F.I.F.O example
Next Topic:	Change Initial Value Property

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:29:41 CDT 2024