>>>Hello:
>>>
>>>Does anyone have code to iterate to all tables in a SQL Server database and issue a 'copy to (tablename).dbf?'
>>>
>>>
>>>TIA
>>
>>If this is a one time job you could use undocumented function MS_ForEachTable:
>>
>>EXEC MS_ForEachTable 'SELECT * FROM ?'
>>
>
>How can you use the results of this in VFP?
The same way you would use any multy recordset query :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.