View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] s99999999s2003@yahoo.com is offline
external usenet poster
 
Posts: 4
Default return multiple results from stored proc

hi

i have a stored proc with multiple select statements in it.
How can i successfully get these results into excel spreadsheet using
ADODB
I have tried

sql = "exec sp_proc "
Set con = New ADODB.Connection
Set rs = New ADODB.Recordset
con.Open "DSN=" & DSN & ";Database=" & DB & ";UID=" _
& User & ";PWD=" & Password

rs.Open sql, con

but after that i am stuck. thanks