>I could use a bit of help here.
>
>I want to copy fields from one table to another. I get a syntax error on the insert into line of my code. I don't think that it is recognizing the name of the table.
>
>Here is my code.
>
>close tables all
>use newmen in 0
>use counttbl in 0
>go top
>scan
> INSERT INTO counttbl (Num,priority,last,first,sex,act,act_length,act_date,; status,trans_num,trans_type,comments1,comments2,;
> add_date,prog_code,trans_stud,new_stud,ret_stud,;
> late_ret_stud,off_stud,temp_stud)
> VALUES (newmen.Num,newmen.priority,newmen.last,newmen.first,"m",newmen.act,newmen.act_length,newmen.act_date,newmen.status,;
> newmen.trans_num,newmen.trans_type,newmen.comments1,newmen.comments2,newmen.add_date,newmen.prog_code,;
> newmen.tran_stud,"y","n","n","n","n")
>endscan
>
>
>Help would be most appreciated. Thanks

Won't "APPEND FROM" or "COPY TO" suite your needs? They could do in one line of code what your doing up there.