Take a look at Creating Client/Server Solutions in VFP help.

>Jim, thanks for the reply.
>
>>>You can use the 'AS' option on each column you select from the MS-SQL table to get back the name. I'm not absolutely positive but I believe if you do a select of the columns in the table and if a column name is longer than ten characters then the resulting cursor will have truncated names. But I do know that you can use the 'AS' option and the column names will return with the name(s) you specify.<<
>
>That's a good idea, but how can I get data from the view/cursor into a table in a .dbc (otherwise the long fieldnames will be lost)?
>
>Alternatively, would it be possible to create a connection (ODBC?) to the SQL tables and use remote views to extract the data, which I can then view using a VFP front-end? Do I already have the necessary software to create the connection? Is it supplied with VFP or the OS (XP pro or W2K)?
>
>Regards,
>Alan