>>I'd suspect the field immediately after the last good field. Is it a memo? One thing to check is to suspend immediately before the Insert line and see what's stored in the array, specially around that field. Sounds like the old scatter-gather glitch when it didn't count the memos.
>>
>>If the array is populated properly, you may try to select the target table and Append From Array.
>
>Dragan,
>It came to me this morning, while taking a shower! It was a memo field that isn't carried over with the COPY TO ARRAY command. It was the first memo field I've used in 4 years, and it will be the last. I'll work out something else.
Something like Scatter Name? Mmmm... nope, there's no insert from name. A simple scatter ... memo should do, since the structures are identical.