Not sure if this is best asked in the import section, or the query section, but thought I'd try here.
I will have a table in Access that has fields ID(Autonum), PartNum(Text), Price(Currency), Legacy(Boolean)
I have pricing data in excel in the format of 2 columns, column A has the part number, and column B has the price.
When I get an updated price list from my vendors, I want to update my access table.
I'm assuming that step one will be importing the excel file into a temporary table, but if there's a better way, I'm all ears.
I want to perform the following updates to compare the new price list to the existing table:
Where partnum matches, update price from temp table to main table (Updated price)
Where partnum is in temp table, but not main table, add partnum and price to main table (New Part)
Where partnum is in main table, but not temp table, change Legacy to "True" (Discontinued part)
Clean up (Remove temp table)
Can anyone point me in the right direction, or post some code snippets I might modify to accomplish this?
Thanks in advance.