Re: Help! Export to Excel spreadsheet

Have you tried accessing the data from within Excel -

        >Data
        >Get External Data
        >New Database Query

..Obviously you will need to setup a DSN, and Oracle Client.

Sybrand Bakker wrote:

> "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 - 21:58:34 CST