Mark

I guess you'll just have to import to an intermediate table, that presumably adopts the Access column names. Don't know if VFP8 incorporates an "insert into Dest_Table select {field list} from Interm_Table"

Or, you could use:

Select {Interm_table_field_1_name) as {Dest_Table_Field_Name}, ...
from Interm_Table
into Dest_Table

then append dest_table recs to the end of your pukka destination table.

HTH
(Although Sergey'll no doubt trump me with a better method :-)

Terry
>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