>>>>>>>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
Fine. If you are unfamiliar with SQL server (any version), at least yo should know that it's typically a "black box". So you must either connect to it using SQLConnect(), or use its tools to export the tables.