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! =-----