You can create a ADO connection to your access table, read the records from VFP tables and use the SQLEXEC to insert data.
1.- Create a ODBC connection from control panel to your access table. P.e
(MyAccesConn)
In VFP
nh=SQLCONNECT("myAccesConn")
Use Mytable
Scan While ! eof()
lcsql="INSERT AccessTable(field1,field2,field3) "+
"Values ('"+mytable.f1+"','"+mytable.f2+"','"+mytable.f3+"')"
nError=SQLEXEC(nh,lcSQL)
If nerror>0
?OK
ENDIF
EndScan
"Anyone who has never made a mistake has never tried anything new." A.E
"The important thing is not to stop questioning. Curiosity has its own reason for existing." A.E