The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024

Latest message you have seen: RE: Re: Whoooosh..thud..oh bugger


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

(OT) VB and Excel Help


  • To: <ukha_d@xxxxxxx>
  • Subject: (OT) VB and Excel Help
  • From: "aashram" <groups@xxxxxxx>
  • Date: Fri, 29 Aug 2003 14:13:43 +0100
  • Mailing-list: list ukha_d@xxxxxxx; contact ukha_d-owner@xxxxxxx
  • Reply-to: ukha_d@xxxxxxx

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]



Home | Main Index | Thread Index

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.