>Long column names are the problem. I took them out and the script worked fine.
>If I try to add the long name back I get the error around column 120. By the way this table has 220 columns including 11 memos.

I vaguely remember similar problem discussed few months ago at tek-tips.com website.

Looks like you found some limitation which is unknown. Would be good to see the whole script.