>>>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.