>>>>>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
You may need to check the value returned from sqlexec() (a number, namely number of cursors returned, if negative, check for aError()). You may have to fiddle with this a while - perhaps some field names are not conforming to Fox's naming and the automatic conversion may not suit you etc etc.