• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 409
  • Last Modified:

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?
0
Vincent_Monaghan
Asked:
Vincent_Monaghan
1 Solution
 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now