Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Easy way to get Oracle data into MS excel
Hi
As others have mentioned there are a load of ways to get Oracle data into Excel. If you want a comma seperated file then what I find the easiest way is to use good ole sqlplus
set colsep , - column seperator character
set feed off head off - don't want excess lines.
spool myfile.csv
select blah..
spool off
HTH
-- Niall Litchfield Oracle DBA Audit Commission UK "GC" <gcerrato_at_gerling.ca> wrote in message news:nmpA5.297815$1h3.6682464_at_news20.bellglobal.com...Received on Fri Sep 29 2000 - 02:58:08 CDT
> I need an easy way to get data from Oracle database into Microsoft Excel
csv
> file.
>
> Thanks
>
>