>>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
>
I temporarily forgot about Fox's powerful SELECT-SQL command; I think I'll go with that one.
Thanks Sergey!