Re: How do I send data made in reports to excel?

Many thanks!!!

CM.

In article <173b7e20.083f66b5_at_usw-ex0102-016.remarq.com>,   mgumbs <mgumbsNOmgSPAM_at_hotmail.com.invalid> wrote:
> To expand on the other threads.
>
> You can either create a tabular layout and specify 'csv' in the
> parameter form output if you are using Reports 6 or above. See
> help/oracle metalink documentation for details
>
> Or
>
> Create your query similar to the following
>
> SELECT '"'|| emp.empno ||'","'|| emp.ename ||'","'||
> emp.salgrade ||'"' CSV
> FROM emp;
>
> This formats your query in CSV format.
> Create a basic layout with the one long field.
> Character mode layout.
> Get rid of any margins.
> DESFORMAT = WIDE (or any other very wide printer definition)
> Send output to file.
>
> You can now import the file into excel as a CSV file.
>
> HTH
>
> M
>
> "Brian Duff" <bduff_at_uk.oracle.com.DELETE_THIS_BIT> wrote:
> >As you say, the easiest way is probably going to involve
 generating to a
> >text file first. The most common way to do this for
 spreadsheets is to use
> >..csv (comma separated value) format. Export an XLS file as CSV
 from Excel to
> >see an example of this.
> >
> >Brian
> >
> >Corto Maltese <corto_at_castel.nl> wrote in message
> >news:8iqjqi$7i4$1_at_nnrp1.deja.com...
> >>
> >>
> >> Hi all,
> >>
> >> Is there any way to get the data retrieved with Reports 2.5
 send or put
> >> (semi)automatically to Excel??
> >>
> >> It can always be done sending the output to file, but doing
 this it
> >> must be parsed to column, formatted etc., there may be a
 easier way...
> >>
> >> Thanks on ferehand,
> >>
> >> CM.
> >>
> >>
> >>
> >> Sent via Deja.com http://www.deja.com/
> >> Before you buy.
> >
> >
> >
> >
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jul 03 2000 - 00:00:00 CEST