Re: Convert Oracle data to EXCEL

From: <elkadiki_at_my-deja.com>
Date: Thu, 14 Dec 2000 23:58:51 GMT
Message-ID: <91bmro$mks$1@nnrp1.deja.com>

You can separate your results with a comma, i.e.:

select col1, ",", col2, "," col3 from table .....

Then you can rename your output to <file_name>.csv and Excel will be able to open as a "Comma Delimited File" or CSV.

So, SQL*Plus will work with this solution. Also, if you can get SQL- by Quest software you can export to a file in CSV.

Good luck,

Sal Elkadiki
E-mail: elkadiki_at_hotmail.com

In article <919fnh$sn5$1_at_nnrp1.deja.com>, amycooley_at_my-deja.com wrote:
> Anyone knows how you can convert Oracle data to Excel ? SQL Plus is
> not very user friendly. Thanks.
>
> Amy Cooley
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Dec 14 2000 - 17:58:51 CST