How can I read multiple ADO recordsets into Excel using VBA

I have a stored procedure in an MS SQL Server 2008 R2 database that returns multiple recordsets which works very well from my .NET application. My customer nows wants to drop the same data in MS Excel. Is there a similar object in VBA as the .NET dataset that can read muliple recorsets?
Vincent_MonaghanAsked:
Who is Participating?
 
Rory ArchibaldCommented:
You can return multiple recordsets into an ADO recordset object in VBA and then use the Recordset's NextRecordset method to move from one to the next.
0
 
Vincent_MonaghanAuthor Commented:
Thanks Rorya
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.