I have an access database with many internal tables. Each table is a category of electronic components (resistor, capacitor etc) In all tables, there is a manufacturer part number and a currently empty field for our internal part number.
I have an excel file containing the internal part numbers and the matching manufacturers part numbers.
How can I fill in the internal part number field for all tables from my excel file, matching on the manufacturer part number?
I'm sure this is simple, but I don't use access much, and I don't speak "accesseze".