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.