Thanks Fernando....

You English is fine... :)

My problem is:

1) All of this must be done programatically and
2) I'm not using a form.... I'm trying to pass all the records in a VFP table to an Access table with no records but the same structure as the VFP table.

I'm just not sure how to do this. If I can create a connection (with the create connection command) do I then create a remote view? and after that how do I get data into the view and then into the Access table?

I've read and re-read the docs and it all seems very confusing. One chapter in the docs goes into detail about setting a remote view up so that it can be updated but then never tells you how to do an update! :(