dead easy ! , use a stored proc to do 2 or more select statements and in
your DA code
dim rs
dim rs1
dim rs2

set rs = obj.getrecordset

set rs1 = rs
set rs2 = rs.nextrecordset
set rs3 = rs.nextrecordset

etc etc
 this will put the first select into rs1, second into rs2 and 3rd into rs3

HTH

T

-----Original Message-----
From: kofi karikari [mailto:kofikarikari@h...]
Sent: 02 October 2000 16:14
To: professional vb
Subject: [pro_vb] returning multiple rows from a stored procedure usind
ADO


Hello colleagues,
Can someone show me how to return multiple rows from a stored procedure 
using ADO?
A sample code will be very much appreciated
Thanks
Kofi