>My Foxpro table does not exist yet. The SQL table structure is always unknown. Then I do not have a Foxpro template, I just need a command to do both... create foxpro table and copy data from sql to dbf. How can I do that in easy way?

Why not simply get the data from SQL Server:

SQLEXEC(nHandle,"Select * from mytable where mycondition")

then just copy the cursor into a DBF.