>Temp folder set to c:\temp but problem is that it doesn't append from cursor created by Select-SQL.

What VFP version you're using? Are you sure that the actual cursor is created (e.g. add NOFILTER clause to your select-SQL).

Also if you use VFP8+, you can use INSERT INTO myTable SELECT ... syntax instead of two steps.