Update query help

[Judd]

I have an excel file, we'll call it R1. I have
information in another excel file, we'll call it X2, that
I need to merge into R1. Column A in both files are the
same. I need to import the information from column H in
X2 to column J in R1, using column A as the reference.

I tried an update query like this:

Field: X2.H
Table: X2
Update to: [R1].[H]

Where I have R1 joined to X2 by column A with the option
of "Include all records from R1 and only those records
from X2 where the joined fields are equal."

It doesn't work. What am I doing wrong?

Someone suggested an append query, but that didn't work
either. Thanks for any help.

 

[[MVP] S.Clark]

Something like:

UPDATE custcopy INNER JOIN Customers ON custcopy.CustomerID =
Customers.CustomerID SET custcopy.CompanyName = [Customers].[CompanyName];

Substitute R1 and X2 for customers and custcopy. Might not be respectively,
may be vice versa.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-