dim arrRecs as variant

arrRecs = rs.GetRows()

--
Tim Williams
Palo Alto, CA


"mazzarin" wrote in message ups.com...
Is it possible to make a query using ado and have the data dumped into
an array for more manipulation? Right now I have a query like this:


strQuery = "SELECT baser, upt, multiplier FROM olb WHERE" & _
" SPR = '" & Range("C2").Value & "'" & _
" ORDER BY id desc"
With rs
.Open strQuery, dbConn, adOpenStatic
Range("J6").CopyFromRecordset rs
.Close

But I would rather do Array.Copyfromrecordset or something like that

The results of the query can be different sizes so I can't predefine
the array size, I think this requires declaring a variable as
'variant', but from there I'm not quite sure where to go.

Thanks for any assistance.