Update Query with linked excel table

[AJ]

I have two tables:

log sheet
log_sheet - linked table from excel (emailed from contractor and saved to my
computer so I can update my database)

They have the same field names, ie: project number, contact person, company
etc.

I need to be able to update the log sheet table with the linked table using
an update query. How would I go about doing this? All of my reports run off
of log sheet and I don't want to have to update it by hand.

Thanks in advance for your time and efforts.

 

[[MVP] S.Clark]

Add both tables.
Link by id fields
Add field to be updated. Set what new value would be.(i.e. field name from
spreadsheet.)
Run query

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

 

[AJ]

Ok

I have added log_sheet (which is linked to excel) and log sheet.
I have joined fpi_log and fpi (join type - only include when equal)
I inserted into query:

field: fpi_log
table: log_sheet
update to: This is where I don't know what to put, I typed fpi which would
be from log sheet. That doesn't work. Do I put the name of the table I want
to update?

I did create an append query, which adds the fields that don't already
exist, but now I need to append those that exist with the new data.