Dave:

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.

Thanks again.

Mike Smith