Importing info from one excel file to another

[Judd]

I have a report [R1]. I need to take data from another
report [X2] and import it into [R1]. The column headings
on both reports are the same, but not in the same order.

[COLUMN LARRY] is the data I will use to link the
information. [COLUMN MOE], [COLUMN CURLY] is the info. I
need to update. As I said before, [COLUMN MOE & CURLY]
are in different column #'s on both excel files (so I'm
wondering if that's messing me up, but as long as the
name is the same, it shouldnt' be).

I have done an update query that is as follows:

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

I've tried the formula above in update query several
different ways and it's not working correctly, it's not
updating the information. Any ideas.

 

[John Vinson]

I have done an update query that is as follows:

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

I've tried the formula above in update query several
different ways and it's not working correctly, it's not
updating the information. Any ideas.

An Update query updates the values of fields in *existing* records. If
you want to add new records to X2, you should use an Append query
instead.