>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.
Imagination is more important than knowledge