Re: Convert Oracle data to EXCEL

The disadvantages of using Oracle Reports is that the data is readonly and you cannot copy and paste it from there. Furthermore it's rather large and expensive. The latter also holds for Discover which may actually allow you to cut and paste but it's rather large and expensive.

Why not use 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 <91fj4j$1sj$1_at_gate.local>,
  richard_at_r-senior.demon.co.uk (Richard Senior) wrote:
> In article <919fnh$sn5$1_at_nnrp1.deja.com>,
> amycooley_at_my-deja.com writes:
>
> > Anyone knows how you can convert Oracle data to Excel ? SQL Plus is
> > not very user friendly. Thanks.
>
> Aside from the other suggestions, you have at least two other options
 if
> you have access to the more recent versions of the Oracle Developer
> toolset. You can use Query Builder to build a query graphically and
 export
> the output to CSV, etc. You can also export data to CSV and other
 formats
> from Oracle Reports -- use the Report Wizard to build a simple report
 and
> generate the output to a file.
>
> I'm not too familiar with Oracle Discoverer but I'm sure that has
 various
> export options too.
>
> --
> Regards,
>
> Richard Senior
>

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