Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can Oracle DB Stored procedure be called in MS Excel?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can Oracle DB Stored procedure be called in MS Excel?
Amol
If not a stored procedure, certainly and Oracle table should be available via OLEDB. If you go in Excel to Import External DataImport data... and select New Data Source... Select Other AdvancedOLEDB 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/datam...rtexternal.htm -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Amol" wrote in message ps.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting numbers stored as dates to text in Excel | Excel Discussion (Misc queries) | |||
how do I import data from oracle version 7 to excel 2002 | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
a template in Excel 2000 called mimic.xlt? | Excel Discussion (Misc queries) | |||
Fonts get size 1 and can't be changed after a procedure - even by excel GUI!! | Charts and Charting in Excel |