Raymond,

A lot will depend on how often you plan to do this.

Create a view to the Access data. Then SELECT from the view, aliasing the field names and put the results into a table. (SELECT Field1 AS MyNewName...)

Alternatively, save as a text file, prepare a CURSOR or TABLE in VFP and use APPEND FROM. The fields will fall into the new table in the order in which they are stored.

>I need to get MS Access tables into VFP. Problem is the MS Access field names are longer than 10 characters. Some of the fields have the same 10-character beginnings.
>
>I tried to Export from MS Access and import into VFP as PDox but all I get is column1, column2, etc.
>
>I tried to run a search but since the word "access" appears in tons of threads that is impossible to limit.
>
>Also have tried using the Excel format.
>
>Thanks,
>Ray.