>>>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.
Something like "SCATTER MEMVAR MEMO" and "INSERT INTO ..... FROM MEMVAR", but I haven't had time to check it out yet. Memos have a reputation for corrupting very easily, and I've stayed away from them until this transgression... I should repent , :), and replace the memo field with a linked rtf file, like I always do.
Nebraska Dept of Revenue