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?

Regards,
Martin


.

Quantcast