>>>>Whats the best way of converting SQL to a vfp table
>>>
>>>Only one table or a complete database? And which SQL version are you talking about?
>>
>>I don't know what SQL version it is - I just need it as 1 table - I think - sorry Tore I am too vague on this one I will have to rethink
>
>Get a handle, then
>
>sqlexec(handle, "select * from mytable", "crsMyTable")
>copy to mydbf
>
>Preferrably with a dbc, so you don't lose long field names.

Thanks will try tomorrow