>Hi Larry:
>
>The structure in the two tables are different. Newschd\Schd.dbf has addtional
>fields.

Then you probably have to go the SCAN...ENDSCAN route and transform your data.

Ex.
select oldtable
scan
   insert into newtable (field1, field2, field3) values (field2, field3, filed1)
endscan

Or set some variables within the loop and modify what you need.