Thread: Run a Stored Procedure from Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
George Thackray George Thackray is offline
external usenet poster
  
Posts: 1
Default Run a Stored Procedure from Excel
Hi. I've had exactly the same problem.
Try this - it worked for me.

Change:
cmdSP.CommandType = adCmdStoredProc

To:
cmdSP.CommandType = adCmdUnknown

Reply With QuoteReply With Quote