From: gjlinker@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: Re: exporting query data to ms excel
Date: Fri, 02 Feb 2001 16:44:56 GMT
Organization: Deja.com
Lines: 28
Message-ID: <95eo63$6mm$1@nnrp1.deja.com>
References: <9571gv$gh6$1@nnrp1.deja.com>
NNTP-Posting-Host: 194.131.250.1
To: steveallen3454@my-deja.com
X-Article-Creation-Date: Fri Feb 02 16:44:56 2001 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)
X-Http-Proxy: 1.0 x60.deja.com:80 (Squid/1.1.22) for client 194.131.250.1
X-MyDeja-Info: XMYDJUIDgjlinker


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@nnrp1.deja.com>,
  steveallen3454@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/