Import a set of values from Excel given a match on a criteria "CodeMonkey" <agaskelluk[ at ]yahoo.com> 11.07.2006 22:29:16 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

Re: Import a set of values from Excel given a match on a criteria John Nurick <j.mapSoN.nurick[ at ]dial.pipex.com> 13.07.2006 20:14:59 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. On 11 Jul 2006 15:29:16 -0700, "CodeMonkey" <agaskelluk[ at ]yahoo.com> wrote: [Quoted Text] >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 -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email.