Re: Help!-TRANSFER FAST TO EXCEL

I asked the same question in this forum recently so you might look for that thread.

There are three approaches that seem promising to me at the moment. (I'm not at all a database kind of guy so there may be much better ways):
- Use SQL+ and spool the data to a file which you import into Excel - Use the OO4O (Oracle Objects for Ole) which you can download from the Oracle website. There are some examples how to write VBA Excel macros that get data through those objects. - Use SQL XL, which you can download (a limited version) from the www.oraxcel.com website.

My preliminary tests seem to suggest that this is much faster than going through ODBC/MS Query

Andrew

"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 Wed Mar 28 2001 - 19:43:16 CEST