How do I copy the structure of a remote view in a DBC to a new DBF in the DBC with long file names.

I have a remote view of an SQL table, I want to create a DBF with the same field names, but the SQL table has long field names.

I thought I could use :



OPEN DATABASE XX.dbc
Use xxsqlremote_view && defined in dbc
Browse &&works fine and I see all data
COPY STRUCTURE TO new.dbf database XX.dbc && seems to work
Use new &&should be structure of SQL remote view but does NOT work

This always gives me an error saying :

xx.dbc Cannot link table new.dbf to this database: duplicate or missing fields. Would you like to try to locate owning database or delete the link (and free the table)?