Re: Convert Oracle data to EXCEL

It sounds like you've been down this route before... Have you actually heard of SQL*XL which allows you to pull data into your spreadsheets without actually leaving Excel?

You may be able to 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 <91a3ra$brr$1_at_nnrp1.deja.com>,   Luggy <dgh_consulting_at_my-deja.com> wrote:
> Hi Amy.
>
> Your easiest options are:
>
> 1. Use MS Query via ODBC (Data > Get External Data > Create New
 Query).
> 2. Install oraxcel, and use it.
> 3. Create a CSV file in Oracle. Excel can use that.
>
> To make a CSV (option 3) for the following table...
>
> ATABLE
> COL_A DATE
> COL_B VARCHAR2(10)
> COL_C NUMBER(5)
>
> ...you could use the following script in SQL*Plus...
>
> ------------------------cut--------------------------
> set linesize 32767
> set trimspool on
> set termout off
> set pagesize 0
>
> spool atable.csv
>
> select COL_A||','||COL_B||','||COL_C
> from atable;
>
> spool off
> ------------------------cut--------------------------
>
> To create the above file dynamically for multiple tables, I have
> written a PL/SQL script. Please let me know if you'd like this (I can
> email it if so).
>
> HTH,
>
> Dave Henderson.
>
> Sent via Deja.com
> http://www.deja.com/
>

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