Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match / Index multiple criteria return multiple results | Excel Worksheet Functions | |||
How to return multiple results in a cell | Excel Discussion (Misc queries) | |||
how to return multiple results in vlookup? | Excel Worksheet Functions | |||
execte stored proc | Excel Programming | |||
Return Multiple Results with Lookup | Excel Worksheet Functions |