>Simplified
>use table.dbf
>
>go top
>scan
>INSERT INTO sqltablepersons where person1 from dbf

IF by that you mean

INSERT INTO sqlTablePersons (field1, field2) ;
SELECT field1, field2 from person2 ;
where personid = person2

You will need an index on the VFP DBF for your person id field.

>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