RE: (OT) VB and Excel Help

[Mark Hallows <markhallows@xxxxxxx>]

Did you get my ? ref the roomba for sale ? I replied to you offlist at
Groups@xxxxxxx


Mark Hallows
Senior Systems Analyst

Pankhurst Design and Development Ltd
85-87 Richford St
London W6 7HJ
Tel:  +44(0)20 8735 1111
Fax  +44(0)20 8735 1122
mailto:MarkHallows@xxxxxxx <mailto:MarkHallows@xxxxxxx>
http://www.pdd.co.uk <http://www.pdd.co.uk/>


This e-mail is private and confidential and is intended solely for the
person it is addressed to. Any disclosure, distribution, copying or
printing, or use of the information contained herein for whatever purpose
by
anyone other than the recipient is prohibited and legal action may be taken
as a result.


-----Original Message-----
From: aashram [mailto:groups@xxxxxxx]
Sent: 29 August 2003 14:14
To: ukha_d@xxxxxxx
Subject: [ukha_d] (OT) VB and Excel Help


Can anyone suggest a better way to do this

I want to output the contents of an sql query to an excel doc. I have
managed to do it by treking through the recordset row by row and coping it
to an excel.application object cell by cell. This takes forever as there
are
50000+ rows in the recordset. Is there a better way (speeder) to copying
the
recordset to an excel doc ?





[Non-text portions of this message have been removed]