"The Vision Thing" wrote ...

I use getRows a lot to write a
recordset into an array
You can then write the array to the spreadsheet (you'll need to convert it
from base 0 to base 1)

By amazing coincidence, on an unrealted matter I just turned up this
thread from the archive:

http://groups.google.com/groups?thre...gp13.phx .gbl

Tom Ogilvy was correct: no problem writing a base 0 array to a Range.
You replied, "I believe you cannot directly write an array to a
spreadsheet range
unless it is base(1)" and no one at the time reasserted that your
assumption was incorrect.

Jamie.

--