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

return multiple results from stored proc
 

once the recordset is populated

use excel's CopyFromRecordset method

note: I would avoid the DSN approach
users without the DSN will not be able to run your code.

define the connection in your connectstring.
many examples on:
http://www.carlprothman.net/Default.aspx?tabid=81



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


wrote :

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