Importing weekley exces spreadsheets into Access and have it update changed fields

[Cmitchell]

I have a spreadsheet that i want to import into access. I can import the first weeks just fine. But in the Acess I have added fields that will not be availalbe in the excel spreadsheet that I import. I don't want to import duplicates but - let's say for project no. 123456 it's status is planning for the first week. Then the next week when I go to import the spreadsheet the status has changed to CLOSED. Then I want the database table to be updated with CLOSED for that project no. I can't seem to get it to import and update just certian fields. I also don't know how to write code to do this. Any help would really be appreciated. Thank you.

[pkstormy]

1. Import your table.
2. Design a query which matches/links the identifying field (or name match or whatever field) to your main table.
3. Change this to update whatever field you need to update.
4. Design an 'Unmatched query' on your import table against the 'matching' query.
5. Change the Unmatched query to an append query to append data to your main table.
6. Then use these queries to run in your code.