Update or append?

[Petros]

Hi all...
Table A. 10 fields. Field 1, Primary Key.
At the date entry process it is only necessary to populate Field 1 and 2, i then want to update the remaining 8 fields at a later occasion.
I receive a report externally with Field 1 – 10 populated...but how do i update Table A with this report..to add the remaining 8 fields to the already existing filed 1 and 2?
Thankful for suggestions

 

[Galaxiom]

Import the source data to a table. Join the imported table to table A on field 1 in an Update query. Update the fields except for field 1 (and 2).

 

[Petros]

Import the source data to a table. Join the imported table to table A on field 1 in an Update query. Update the fields except for field 1 (and 2).

Thank you, i will try this approach and let you kow the outcome, much appriciated.