>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.
Your best bet would be to use a remote view or SQL Passthrough into the Access database.
If you need to use an actual VFP table (i.e., a DBF not just a cursor), then you have to copy or append the data from the remote view or SPT result into a table that's part of a database in order to keep the long field names.
Insanity: Doing the same thing over and over and expecting different results.