Import a set of values from Excel given a match on a criteria

  • Thread starter Thread starter CodeMonkey
  • Start date Start date
C

CodeMonkey

Hi all
I have an access table with a set of power values against product
(amongst other fields) e.g.

Product Power
pig 45
cow 100
sheep 450

I have an excel spreadsheet with the same fields, field1 is always the
product and field 4 is always the Power value. How do I get access (or
excel) to update the Power values for pig, cow, sheep and so on based
on the values in the excel spreadsheet automatically?

Thanks
Andrew
 
Hi Andrew,

Set up a linked table connected to the worksheet (using the File|Get
External Data|Link menu command or, in VBA, DoCmd.TransferSpreadsheet).
Then create an update query that joins the linked table and your
existing table on the Product field and updates the value of Power.
 
Back
Top