Have you tried to use the following syntax to insert data into the Access database?

INSERT INTO ["c:\anydatabase.mdb"].TableName(Field1, Field2)
SELECT Field1, Field2
FROM TableName

If you execute this against your FoxPro connection to insert data into the Access table, it should work. I usually create a temp table that I can then use to run queries against. One more step when using VB, but it is not that bad.

Jason