You can use OLE2 (from Oracle forms for instance) for all the job.

There is also a very nice tool SQL*XL which simplify access from excel
to oracle very much.
If not using it, you can pool data from oracle via ODBC.

And finally You can use latest MS office: There is row limit moved from
64k rows to 2G rows!!!

KAzi


ravi.v wrote:
> Hi Experts,
>
>
>
> Can somebody help me in pushing the output of a SELECT statement into excel
> sheet.
>
> Also if the table is too huge (2 million rows) how to select the data from
> the table in splits for example: first 50,000 rows and next 50,000 rows and
> so on.
>
>
>
> Help in this regard would be highly appreciated.
>
>
>
> Kind Regards,
>
> Ravi.
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>


Oracle LazyDBA home page