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

Martin B wrote:

> 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?
>
> Regards,
> Martin

this is probably not what you want to hear but my first suggestion
would be to forget SQL sentences for Excel. Try doing it directly per
code.

Additionally, you could try using DisableControls before beginning the
operation and EnableControls after it. That usually helps to make it
faster although I seriously doubt it will solve your problem completely

--
Best regards :)

Guillem Vicens Meier
Dep. Informatica Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam

.

Quantcast