>>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.


The script is very simple but why the long names caused the problem is different story.

The following is example of the script and it goes to 220 columns

CREATE TABLE 'zzz.DBF' NAME 'zzz' ;
(ID C(10) NOT NULL, ;
COL_109 C(4) NOT NULL, ;
COL_110 C(20) NOT NULL, ;
COL_111 C(50) NOT NULL, ;
COL_112 C(4) NOT NULL, ;
COL_113 C(4) NOT NULL, ;
COL_114 C(4) NOT NULL, ;
COL_115 C(4) NOT NULL, ;
COL_116 C(4) NOT NULL, ;
COL_117a L NOT NULL, ;
COL_117b L NOT NULL, ;
COL_117c L NOT NULL, ;
COL_117d L NOT NULL, ;
COL_117e M NOT NULL, ;
COL_117f L NOT NULL, ;
COL_117g L NOT NULL, ;
COL_117h C(25) NOT NULL, ;
COL_118 C(20) NOT NULL, ;
COL_119 C(4) NOT NULL, ;
COL_120 C(4) NOT NULL, ;
COL_121 C(4) NOT NULL, ;
COL_122_1_a C(30) NOT NULL, ;
COL_122_1_b1 C(25) NOT NULL, ;
COL_122_1_b2 C(25) NOT NULL, ;
COL_122_1_b3 C(25) NOT NULL, ;
COL_122_1_b4 C(25) NOT NULL, ;
COL_122_1_b5 C(25) NOT NULL, ;
COL_122_1_c1 C(25) NOT NULL, ;
COL_122_1_c2 C(25) NOT NULL, ;
COL_122_1_c3 C(25) NOT NULL, ;
COL_122_1_c4 C(25) NOT NULL, ;
COL_122_1_c5 C(25) NOT NULL, ;
COL_122_1_d1 C(25) NOT NULL, ;
COL_122_1_d2 C(25) NOT NULL, ;
COL_122_1_d3 C(25) NOT NULL, ;
COL_122_1_d4 C(25) NOT NULL, ;
COL_122_1_d5 C(25) NOT NULL, ;
COL_122_1_e C(40) NOT NULL, ;
COL_122_1_f C(4) NOT NULL, ;
COL_122_1_g C(4) NOT NULL, ;
COL_122_1_h M NOT NULL, ;
COL_122_2_a C(30) NOT NULL, ;
COL_122_2_b1 C(25) NOT NULL, ;
COL_122_2_b2 C(25) NOT NULL, ;
COL_122_2_b3 C(25) NOT NULL, ;
COL_122_2_b4 C(25) NOT NULL, ;
COL_122_2_b5 C(25) NOT NULL, ;
COL_122_2_c1 C(25) NOT NULL, ;
COL_122_2_c2 C(25) NOT NULL, ;
COL_122_2_c3 C(25) NOT NULL, ;
COL_122_2_c4 C(25) NOT NULL, ;
COL_122_2_c5 C(25) NOT NULL, ;
COL_122_2_d1 C(25) NOT NULL, ;
COL_122_2_d2 C(25) NOT NULL, ;
COL_122_2_d3 C(25) NOT NULL, ;
COL_122_2_d4 C(25) NOT NULL, ;
COL_122_2_d5 C(25) NOT NULL, ;
COL_122_2_e C(40) NOT NULL, ;
COL_122_2_f C(4) NOT NULL, ;
COL_122_2_g C(4) NOT NULL, ;
COL_122_2_h M NOT NULL, ;
...