General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only