>>>hi all,
>>>
>>>I need to import data from an Access table into a FoxPro table - the names of the fields/columns are different in each table - how can I map the Access table columns to the FoxPro table columns?
>>>
>>>Thanks
>>
>>Did you try my previous reply?
>>If YOU don't know relations between Access Tables and VFP Tables (fields are also included here) who else should know this?
>
>Your previous reply worked for opening an Access table - thanks. What I am trying to do is create an Import program so that end users can select an Access table - columns unknown - and import its contents into our FoxPro table - columns known. Any ideas how best to approach this?
>Thanks.

Check SQLTABLES(), SQLCOLUMNS() in HELP, you could build cursors for bot VFP and ACCESS Table then, with some UI you could MAP fields from ACCESS Table to VFP ones.