Home » Developer & Programmer » Forms » send oracle table to excel (forms 6i)
send oracle table to excel [message #439918] Wed, 20 January 2010 02:40 Go to next message
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
Re: send oracle table to excel [message #440376 is a reply to message #439918] Sat, 23 January 2010 00:55 Go to previous messageGo to next message
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
Re: send oracle table to excel [message #440432 is a reply to message #439918] Sun, 24 January 2010 15:36 Go to previous message
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
Previous Topic: Need F.I.F.O example
Next Topic: Change Initial Value Property
Goto Forum:
  


Current Time: Sun Dec 04 04:39:43 CST 2016

Total time taken to generate the page: 0.05850 seconds