Simplified
use table.dbf

go top
scan
INSERT INTO sqltablepersons where person1 from dbf
INSERT INTO sqltablepersons where person2 from dbf
INSERT INTO sqltablepersons where person3 from dbf
insert into sqltablevehicle
insert into sqltableletter

endscan

I am also doing some seeks into other dbf's during the scan and a couple sql select statements to see if records already exist in the sql tables before inserting, eveything runs efficiently except the sql inserts