Re: UPDATE SQL for Excel - very slow - any suggestions?
- From: Brian Bushay TeamB <BBushay@xxxxxxxxx>
- Date: Tue, 24 Jan 2006 19:29:19 -0600
>I just tried that.
>It is too slow, and I also need to create columns that may be missing in the
>input table.
>I am using a memory table instead.
>By the way, doesn't the ADODataSet use UPDATE SQL in the background?
Usually but the exception is using the Jet Oledb driver when you are operating
in TableDirect mode.
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.
- References:
- UPDATE SQL for Excel - very slow - any suggestions?
- From: Martin B
- Re: UPDATE SQL for Excel - very slow - any suggestions?
- From: Brian Bushay TeamB
- Re: UPDATE SQL for Excel - very slow - any suggestions?
- From: Martin B
- UPDATE SQL for Excel - very slow - any suggestions?
- Prev by Date: Re: TCustomADODataSet.Clone and Calculated fields
- Next by Date: Re: master detail with ADO recordsets
- Previous by thread: Re: UPDATE SQL for Excel - very slow - any suggestions?
- Next by thread: Integer array as BLOB
- Index(es):
Relevant Pages
|