Select youroldtable Scatter name dataholder && creates an object with all the fields as properties dataholder.field1=yournewdata && if yo need to change the data dataholder.field2=yournewdata && repeat for all necessary fields .. Select * from youroldtable into table yournewtable where .F. && Creates a new empty table Insert into yournewtable from name dataholder