>>>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.