[Date Prev][Date
Next][Thread Prev][Thread Next][Date
Index][Thread Index]
RE: (OT) VB and Excel Help
- To: <ukha_d@xxxxxxx>
- Subject: RE: (OT) VB and Excel Help
- From: "Alex Monaghan" <ha@xxxxxxx>
- Date: Fri, 29 Aug 2003 14:36:22 +0100
- Mailing-list: list ukha_d@xxxxxxx; contact
ukha_d-owner@xxxxxxx
- Reply-to: ukha_d@xxxxxxx
If it's MS SQL Server, what about using DTS, you can specify a connection
as
an excel file and then simply write to that connection.
> -----Original Message-----
> From: aashram [mailto:groups@xxxxxxx]
> Sent: Friday, August 29, 2003 2:14 PM
> 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]
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~--> Buy Ink Cartridges or Refill Kits
> for Your HP, Epson, Canon or Lexmark Printer at Myinks.com.
> Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/IBOolB/TM
---------------------------------------------------------------------~->
** UKHA2004 BE THERE! ** - start planning now.
http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx
Subscribe: ukha_d-subscribe@xxxxxxx
Unsubscribe: ukha_d-unsubscribe@xxxxxxx
List owner: ukha_d-owner@xxxxxxx
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Home |
Main Index |
Thread Index
|