Home » SQL & PL/SQL » SQL & PL/SQL » report conversion in excel
report conversion in excel [message #38710] Tue, 07 May 2002 22:52 Go to next message
Bhag Singh
Messages: 36
Registered: May 2002
Member
i want to know that when we make reports in oracle and make spooling,can we save that report in excel format directly.if there is a solution please give me.
thanks very much in advance.

Report message to a moderator

Re: report conversion in excel [message #38716 is a reply to message #38710] Wed, 08 May 2002 04:44 Go to previous messageGo to next message
Rick Cale
Messages: 111
Registered: February 2002
Senior Member
One way would be in your select statement to separate fields by a comma and save as a csv file then import
into excel

Report message to a moderator

Re: report conversion in excel [message #38733 is a reply to message #38710] Thu, 09 May 2002 04:44 Go to previous message
Phenoracle
Messages: 35
Registered: March 2001
Member
Hi,

I have posted a downloadable example on my site that creates a excel file from reports...

Have fun

Report message to a moderator

Previous Topic: foreign key defined on thre fields
Next Topic: missing Parenthesiss
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 07 21:56:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.