>Hi Dave:
>
>Thank you for your reply.
>
>The section on Remote Views is quite well documented in the help files, so I was able to create a remote view (called userfile_remote_view) of the MySQL file Userfile.
>
>The file Userfile has 3 fields: username, password and date1. They are all VARCHAR(30) textfields.
>
>I then created a VFP Table in the DBC called Table1 with 3 fields username, password and date1, all text 30 characters wide.
>
>I am trying to append the data in the Remote View to Table1. How would I go about doing this?
use rview
select table1
append from dbf("rview")
or, in VFP9 you could
use rview
insert into table1;
select * from rview