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