Mike,

I'm glad you got it working. As with VFP there are always several alternatives, here's another couple:

*XBase
use TheView in 0
select TheTable
append from dbf( "TheView" )

* SQL
select * ;
   from TheView ;
   into table TheTable

>I found the answer! There are 3 versions of the Append command and the 3rd version applies to my situation and it works! i.e.
>
>INSERT INTO table1 (username, password, date1) ;
> SELECT username, password, date1 FROM usefile_remote_view
>
>Thanks for getting me started. My success with the Help Files has not always been great but this time I was able to find my way.