Re: Easy way to get Oracle data into MS excel

From: Eoin Gardiner <eoin7_at_my-deja.com>
Date: Wed, 27 Sep 2000 20:06:52 GMT
Message-ID: <8qtk0l$h09$1@nnrp1.deja.com>

In article <nmpA5.297815$1h3.6682464_at_news20.bellglobal.com>, "GC" <gcerrato_at_gerling.ca> wrote:
> I need an easy way to get data from Oracle database into Microsoft
Excel csv
> file.
>
> Thanks
>

Getting Oracle data into Excel is easy.
Set up an ODBC connection to your Oracle database. Open Excel.
Under the data menu select Get External Data - Create New Query You will be able to select your ODBC source and then the tables you want to bring into Excel.
If you do not have a full installation of Excel, you may need to add the Microsoft query add-on. This too is easy - look in the help.

HTH. Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 27 2000 - 15:06:52 CDT