>>Does anyone know of a way to create a VFP table from a SQL Server table?
>>
>>TIA,
>
>

>SQLEXEC(sqlH, "SELECT * FROM SqlTable WHERE 1=0","crsVFPCursor")
>SELECT crsVFPCursor
>
>** 1.Using AFields
>    AFIELDS(laFlds)
>    CREATE TABLE MyVfpTable FROM ARRAY laFlds
>
>** 2. Just copy
>   COPY crsVFPCursor TO MyVfpTable && See HELP for details
>

Why not just:

SELECT * FROM crsVFPCursor INTO TABLE MyVFPTable