Matching Records and updating

[tialongz]

Access 2003

Hi everyone,

I have 2 excel files. First file is the main table. The second file (update file) include 2 columns. Both have 1 column in common - ID column (unique key). I need to insert the the second column in the second file into the main table, using the common column to match the records.

Someone said use the vlookup function? I have no idea how to operate it.

thanks in advance.

[Bob Phillips]

Not being funny mate, but it is easy and the Help file describes VLOOKUP well. Check it out and post back if you can't implement it.

[austenr]

One has to wonder what Access has to do with it.

[austenr]

see if this query does what you want?

[XLGibbs]

Update [MainTable]
Set [ColumnName] = table1.[ColumnName]
From Table1 inner join [MainTable] on Table1.UniqueID = [MainTable].UniqueID