View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arron Arron is offline
external usenet poster
 
Posts: 3
Default How to use Excel VBA program to execute SQL SERVER stored procedur

Dear all,
I want to use Excel VBA program to execute SQL SERVER stored procedure.
But error occurs."Error sql statement ,except Insert update delete procedure"
How can I correct this ? thanks

code:
sqlstr = "exec stored_proc_name('Parameter')"
Sqldb.Execute sqlstr