update query 1

[WorkWatching]

hy guys

plz help

i have imported with ODBC a FoxPro Table which i have to add some more field, till now, no problem

now i have to import again the same table, but i need to update the old one, the fields i add must stay, the rest of the fields have to update (if there are more record, to add, or old oane changed)

plz help

tx

 

[JerryKlmns]

UPDATE OldImported As O RIGHT JOIN NewImporting As N ON
O.PrimaryKey = N.PrimaryKey
Set O.FieldName1 = N.FieldName1,
O.FieldName2 = N.FieldName2,
...
O.FieldNameLast = N.FieldNameLast

 

[WorkWatching]

tx, it works