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

it what i have been given - please excuse me i will go back to my source