Re: Help!-TRANSFER FAST TO EXCEL
Date: Fri, 30 Mar 2001 23:11:34 +0100
Message-ID: <9a308q$gpg$1_at_news.europeonline.net>
Hello,
It looks like my utility SQL*XL is ideal for you. SQL*XL links Oracle databases to Excel. You can pull data straight into Excel without having to bother with csv files, formatting, odbc, etc... You just type the SQL and look at the data coming in...
SQL*XL is available from http://www.oraxcel.com
Gerrit-Jan Linker
"eddie" <elna_at_zebra.net> wrote in message
news:3ABF2F30.A76BE43E_at_zebra.net...
>
> I'm running a passthrough query against an Oracle
> database and want to export the
> data to an Excel Spreadsheet fast! Something like
> Crystal Reports Print>Export function. It seems no
> matter what I do, the exporting of data to an excel
> spreadheet using MS Access is terribly slow. I'm
> exporting data from a query that results in 16,000
> records. I noticed that the print function is fast. Perhaps there is
> an SQL code I can use to take advantage of the power of oracle?
> If there was only a way to print or spool or insert my query results
> to an Excel Spreadsheet.
>
> Please can anyone help?
> ELNA_at_ZEBRA.NET
>
Received on Sat Mar 31 2001 - 00:11:34 CEST