return multiple results from stored proc

[[email protected]]

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

[keepITcool]

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


[email protected] 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