Re: exporting query data to ms excel

From: <gjlinker_at_my-deja.com>
Date: Fri, 02 Feb 2001 16:44:56 GMT
Message-ID: <95eo63$6mm$1@nnrp1.deja.com>

I wrote a utility called SQL*XL to do this. SQL*XL sits in Excel and lets you pull data straight into your worksheets. The other way around works also. You can push the data into Oracle from your spreadsheet without having to code the insert statements. Just a select and click procedure.

SQL*XL can be found at http://www.oraxcel.com

Regards, Gerrit-Jan Linker

In article <9571gv$gh6$1_at_nnrp1.deja.com>, steveallen3454_at_my-deja.com wrote:
> Moving from sql server to oracle. We are tasked with running sql
> queries and transforming the results to ms excel format for our
> analysts. This is easy with sql server; just use the transformation
> tool in the Enterprise Manager. What is the best approach in oracle?
> Are there tools available for this or is the only option to spool the
> output, import the ascii file to excel, and kvetch about how the
> formatting is always incorrect?
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Feb 02 2001 - 10:44:56 CST