Am I able to import modified X pricing table into the existing X

[TCARR]

pricing table and have access only update the prices that have changed? Thanks...

Terri

 

[HowieG]

Try this Update query:

UPDATE tblPriceList INNER JOIN tblNewPrices 
ON tblPriceList.ItemID = tblNewPrices.ItemID 
SET tblPriceList.Price = tblNewPrices.Price;