>>>You can not use parameter the way you're using. The SELECT * from tableName should be send as is, e.g.
>>>
>>>sqlCommand = 'select * from ' + tableName + ';'
>>>
>>>You can probably send several commands at once and use multiple result sets (say, do 10 tables in one command).
>>
>>
>>That worked. Now how to deal the the Copy to variable?
>
>What exactly do you mean? What is your new code and what do you need help with?

Once I have the complete table in the cursor I want to copy that data to a foxpro table

2 more steps needed

1) Identify the table name Ex arjob
2) Copy the cursor to c:\a\arjob as a foxpro DBF

I believe Copy To by default goes to a DBF