ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is it possible to run an Oracle PL\Sql procedure within Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/254103-possible-run-oracle-pl%5Csql-procedure-within-excel.html)

mowee

Is it possible to run an Oracle PL\Sql procedure within Excel?
 
Is it possible to run an Oracle PL\Sql procedure within Excel?

Bob Phillips[_4_]

Is it possible to run an Oracle PL\Sql procedure within Excel?
 
Yes, but you would need to use ADO to setup the commandtext to issue to the
database, and process the results.

Do a Googl on 'ADO Oracle Stored Procedure'. Top result is
http://support.microsoft.com/kb/176086

HTH

Bob

"mowee" wrote in message
...
Is it possible to run an Oracle PL\Sql procedure within Excel?





All times are GMT +1. The time now is 06:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com