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

EXCEL VBA - ADO for multiple datasets

Hi

using ADO, I'm executing a stored procedure that should return 2 datasets in a recordset object

PROBLEM: when i "dump" the data into a spreadsheet i only see dataset #1.

Is there a way to extract each dataset from the recordset?
0
gordonn
Asked:
gordonn
1 Solution
 
MikeTooleCommented:
If rs is the recordset object you retrieve then use the following to advance to the next recordset after you've processed the first one:

Set rs = rs.NextRecordset
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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