Don't think so William, you need to handle that.

By the way, on the original question, there is also the GetRows method that
load an RS into an array

arrayData = oRS.GetRows

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"WIlliam Barnes" wrote in message
...
One other thing, now that I think of it. What about the reverse? Is there
an
easy way to generate a Recordset from a Range object?
"Bob Phillips" wrote in message
...
Hi William,

Range("A1").CopyFromRecordset rsData
which uses part of the Excel Object Model (Range), and the CopyRecordset
method.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"William Barnes" wrote in message
...
Using Excel 2000 under Win 2K Pro with ADO 2.5

Does Excel provide any easy way to copy the results of a database
query
(in
the form of an ADODB.Recordset object) onto a Worksheet? Any thing as
easy
as assigning an array to a Range? Or do I have to loop through all the
Fields for each record and copy them "manually"?




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----