Re: UPDATE SQL for Excel - very slow - any suggestions?


>Hello world,
>
>I am using ADO components to connect to a datasource; the user can
>connect to Excel sheets, Access or any other database.
>
>After using the program, the user will want to update certain fields in the
>datasource.
>I have implemented this with standard "UPDATE" SQL queries.
>This works fine with Access. But with Excel sheets it is very slow (factor
>60).
>This is probably due to the fact that there is no index in the key fields in
>Excel.
>
>Any suggestions?

Don't use SQL
Use a TadoDataset set the commandType to cmdTableDirect
commandText to the data*** you want to edit
Then make all your changes directly to the tadoDataset
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Quantcast