>>>>>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.
>
>Sorry I dont understand - my sql file is uk-postcode.sql
>
>How do I convert it to mypostcode.dbf?
>
>Thanks for your help

And what's the back end? I ask, since no SQL server that I know of uses sql as a file extension.