>Does anyone know how I can append records from an access database into my VFP 7.0 database?

You can connect to the access database with either:
SQLCONNECT()
or
SQLSTRINGCONNECT()

So if your access database has a DSN in the ODBC:
nHandle=SQLCONNECT('MyAccessDSN')

Then use SQL to get the Access table Data into a VFP cursor:
nSuccess=SQLEXEC(nHandle,"SELECT * FROM MyAccessTable","MyAccessCursor")

Then parse your cursor to the table.