>You English is fine... :)
Yeah, but apparently yours isn't. :-)
>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?
Yes.
> and after that how do I get data into the view and then into the Access table?
Once the view is in a DBC, you can use it just like a table. IOW: USE MyRemoteView.
>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! :(
Check into TABLEUPDATE(). You should be able to get the following to work:
1. Create connection.
2. Create remote view, setting up for updates, as you've read in the docs.
3. USE MyRemoteView.
4. Modify data in whatever manner you choose. (BROW, REPL, whatever.)
5. TABLEUPDATE(). (You might need to issue TABLEUPDATE(.T., .T.))
Mike Stewart