Re: Convert Oracle data to EXCEL

To avoid all the hassles to plonk the data into csv files and read them back in I wrote SQL*XL, the Oracle to Excel link.

SQL*XL adds a new menu item to Excel. In a dialog box you type your SQL and the data flows directly into your spreadsheet. All nicely formatted and fully integrated with Excel. You can use Excel cells in queries, prepare your SQL on spreadsheets, etc, etc.

SQL*XL is available from www.oraxcel.com

Download your free copy now! http://www.oraxcel.com/projects/sqlxl

Kind regards, Gerrit-Jan Linker

In article <91bmro$mks$1_at_nnrp1.deja.com>,   elkadiki_at_my-deja.com wrote:
> 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-
> Navigator 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/
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Dec 20 2000 - 06:51:50 CST