Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Report Writer 3.0
I always use ',' as field seperator. the sql statement looks like:
select field1 || ',' || field2 ||',' || ......from table;
in excel, you open the document and specify the ',' is the seperator and it always works.
HTH John Chiu
Kasi <kskasi_at_netscape.net> wrote in message
news:384CA9AA.4CC602E7_at_netscape.net...
> Hello everone
>
> I'm trying to send output from one of my reports on to an excel file. It
> send's okay. But the problem is, I have 4 columns in my report and all
> of them appear on the same cell in the excel sheet. In my application I
> can't use csv file's either. Any suggesstions...
>
> Thanx in advance...kasi
>
Received on Tue Dec 07 1999 - 05:18:27 CST