I have a table called productTbl with severel fields including an item# field, memo (descriptive) field and an updated (date ) field. Every day I import an updated productTbl from our website. This import has the same structure as existing table and may include new product items, price changes and memo (descriptive) field changes.
I want to compare items in existing table with imported table and insert current date if item memo field is not the same. Eample:
item# item description updated
1002 Large rose pin 7/15/2008