hey,
thanx 4 the help..

i want to insert data frm Mysql to dbf..
Im doing the following

sqlexec(lccon, "select * from mysqltable where source=1", "crsTest")

-->The mysql table has a field called source but this field isnt there in the vfp table. other fields are same.)

insert into myvfptable;
(field1,field2);
values(crstest.field1,crstest.field2)

i KEEP GETTING THE ERROR "COLUMN 'SOURCE' NOT FOUND" why is it looking for the column source in the dbf file???