Excel to Query on an Oracle DB

[acabrera]

Can Excel be used to access and make queries into an Oracle 9i database ?
We sometimes use MS Access to do this but prefer to do it in Excel, if possible, as all our users have Excel. Thank you.

 

[SantaMufasa]

Acabrera,

A ready-to-use package that does exactly what you want is available from:

Linker IT Software Limited
Snikke 6
7833 DM Nieuw-Amsterdam
The Netherlands
tel: +31 (0)591 556 314

Their website where you can read about their "SQL*XL" SQL-to-Excel package is

http://www.oraxcel.com.

At that page, you can read about the package's features and find about about free downloads or how to order their software and support.

There are many other options available. You can Google with the search term: "Use Excel to Query an Oracle Database".

Let us know of your success.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 00:34 (07Dec04) UTC (aka "GMT" and "Zulu"),
@ 17:34 (06Dec04) Mountain Time

 

[taupirho]

Acabrera,

To get the best peformance when linking Oracle to EXCEL use
Oracle Objects for Ole (OO4O)

Regards,

Tom Reid