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

Home -> Community -> Usenet -> c.d.o.misc -> Re: fetch oracle with excel

Re: fetch oracle with excel

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 14 Feb 2000 21:26:16 +0100
Message-ID: <950560448.8378.1.pluto.d4ee154e@news.demon.nl>


Three methods
1

- get an Oracle ODBC driver
- setup a connection to the ODBC database.
- use Microsoft Query (included with Excel) query the database
2 write a query in sql*plus to dump the data to Access. 3 search the Deja archives and/or wait a little while to have Gerrit-Jan Linker to advertise his own add-on.

Hth,

Sybrand Bakker, Oracle DBA

R.G. Vervoort <royv_at_rojaal.com> wrote in message news:889man$n4g$1_at_news1.xs4all.nl...
>
> does anyone know ho I can fetch data from a oracle database into an excel
> spreadsheet
>
> thanks for reply
>
> roy
> The netherlands
>
>
>
Received on Mon Feb 14 2000 - 14:26:16 CST

Original text of this message

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