>hello,
> We need to back up data from a remote ms sql server to V5 FOXPRO database each day into a new directory. I use sqlexec() command to retrieve data in a cursor and I will save it to a table. All the field names are long in ms sql tables is a way I can save all the field names in the same length if I save them in free tables. If not, is a way I can save data into a table in a database using sqlexec() command instead of a cursor???? thanks.
>sherry

Free table field names lenght is limited to 10 characters. You've to use database to preserve long names.

= SQLEXEC(...)
CREATE DATABASE testxx
COPY TO testxx01 DATABASE testxx NAME TableWithLongName