>>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?
If it's not broken, fix it until it is.
My Blog 
