Re: Help! Export to Excel spreadsheet

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 26 Mar 2001 18:53:51 +0200
Message-ID: <tbutvrbud7h82b@beta-news.demon.nl>

"eddie" <elna_at_zebra.net> wrote in message news:3ABF2E04.24F5277B_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. Is there an PL/SQL
> code I could use to take advantage of Oracles power?
> I'm exporting data from a query that results in 16,000+
> records. I noticed that the print function is fast. If
> there was only a way to print the results or spooling to an Excel
> Spreadsheet.
>
> Please can anyone help?
> ELNA_at_ZEBRA.NET
>

Get Toad at www.toadsoft.com and with pushing a few buttons you can export to a csv file. The rest should be easy.

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Mar 26 2001 - 10:53:51 CST