>I am trying to append records from a remote view into an empty DBF that has only the needed columns. I tried the APPEND FROM command but it keeps putting a .DBF extention on the view name and then saying it can't find it. It also did this when I used an Alias name for the view. How is the syntax different when you append from view as opposed to appending from another DBF?

Try

APPEND FROM (DBF("MyView"))
* Or
INSERT INTO mytable (<field list>)
SELECT <field list> FROM MyView