How can Oracle DB Stored procedure be called in MS Excel?

[Amol]

Hi
I want to call an Oracle DB procedure using Excel. Also, the procedure
puts the processed results in a table. I want to have a report based on
this data( Simple SELECT on the table).

Is it possible?

Thanks in advance

-Amol

 

[Nick Hodge]

Amol

If not a stored procedure, certainly and Oracle table should be available
via OLEDB. If you go in Excel to Import External Data>Import data... and
select New Data Source... Select Other Advanced>OLEDB Oracle Database and
then trip through the wizard. I don't have Oracle so can't get past first
wizard screen to see if it accepts SPs but that should get you on your way.
You can save the connection strings as a file too.

I use SQL here

http://www.nickhodge.co.uk/gui/datamenu/importexternal.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk