>Hi Mike,
>
>>There is a differnce in the write speed and read speed. The write takes pace about 3 times faster than the read.
>
>That's unusual. Normally, it's the write operation that is slower than the read, especially with transactions being involved. Do you have any columns that are memo fields or character fields with more than 254 characters that are not needed in the conversion? If so, you should replace SELECT * with SELECT field list and omit these fields.


Can do events have an impact...
If I run the code with do events in the loop, it executes faster as well. (But still quite slow... i.e. the speed improvement is in minutes...)

There must be a way to speed this up...

Transferring 27,000 records is taking about 2 hours... There is no way I will be able to transfer all the data on a weekend at this rate.

Any more ideas?

TIA,
Mike