Excel And Stored Procedures

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
-----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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
Invalid Column Name Sql-Error :Executing a stored procedure 1
Elapsed Time returned from query 1
porting sql stored procedures between db2 and sql server 2
Linked servers 5
connect to multiple odbc in pass-through query 1
DB2 & Stored Procedure Definitions 0
Error Editing an MS Query in Excel 1

Back
Top