Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Easy way to get Oracle data into MS excel

Re: Easy way to get Oracle data into MS excel

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 29 Sep 2000 08:58:08 +0100
Message-ID: <8r1i2e$j2h$1@soap.pipex.net>

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...

> I need an easy way to get data from Oracle database into Microsoft Excel
csv
> file.
>
> Thanks
>
>
Received on Fri Sep 29 2000 - 02:58:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US