>>Have you tried to make the VFP table part of a VFP database?
>
>Not sure how to do that.
>
>I did able to copy that table (with long fieldname) as a free table, long time ago.
>But I don't remember how to do that again :(
>
>Copy to picklist1
>
>I got the fieldname cut off

Free tables have only short names. The long names are fields in the DBC.
You might try a cursor, this may keep the long fieldname - but only as long as the datasession exists. For tables there is only DBC

Try something like

CREATE DATABASE Testx
CREATE TABLE (....) &&since the database is set, the table will be part of it by default
APPEND FROM ...

or

CREATE CURSOR (....)
APPEND FROM ...