Excel And Stored Procedures

J

JMHMLKN

Can Excel execute stored procedures? I have DB2 Connect ODBC that I am using to try to get to DB2 mainframe tables. I can not use SQL from within Excel for this particular need; I need to execute a stored procedure.
 
P

Peter Atherton

-----Original Message-----
Can Excel execute stored procedures? I have DB2 Connect
Click to expand...
ODBC that I am using to try to get to DB2 mainframe
tables. I can not use SQL from within Excel for this
particular need; I need to execute a stored procedure.
.
Click to expand...
You can create a macro. You might be able to record a lot
of what you need. Tools, Macros, Record New Macro.

Press Alt + F8 to edit the macro

Regards
Peter
 
Top