Hi,

AFAIK there is no way to append data to MS Access tables without ODBC or something equivalent to it. So first of all you will have to access the VFP table and in a second step you will have to use i.e. an odbc-connection to the MS Access table and do something like

 sqlstring = [insert into myaccesstable (myval1) values ("value")]
 sqlresult = sqlexec(myODBCconnectID,sqlstring)
 if sqlresult < 0
  * display message that something went wrong
 endif