You might consider using Bulk Insert. The Upsizing Wizard source code that ships with VFP should give you a good idea how to use it. Of course, depending on your requirements, the Upsizing Wizard may work for you as is, and on the SQL Server side there is DTS.

>I often need to move data from a DBF into MS SQL.
>
>Currently I use Apped from command, but it is slow.
>
>Is there a faster way to move data from a DBF into SQL?
>
>THe DBF and SQL table has exact same format.