I have an Access table called "Manufacturers". It has an AutoNumber column called "ManufacturerPK" and a text column called "Manufacturer Name". I am constantly being given new lists in Excel that must be used to replace the entire table in the order that it appears in Excel. This creates a nightmare because
the key values in the "ManufacturerPK" column are already being used all over the database so I need to make sure that the same "ManufacturerPK" matches each "Manufacturer Name". How do I reload the table with new information without losing these matches?