In Access, using VBA or a Query, I would like to replace some fields. I have a table called 'Replacements' with 2 columns, column 1 with a name and column 2 a corresponding classification.
What I would like to do is search another table called 'Main Data' which has over 1 million records. In that table, I have the names in the 2nd column (this is the column I would like to search) and the corresponding classification in the 13th column.
Is it possible to search Column 2 in 'Main Data' for the names in column 1 of the 'Replacements' table and replace the classification field in the 13th column of the 'Main Data' table withe the classification in column 2 of the 'Replacements' table.
I'm not sure if this can be done straight forward using a Query of some sort, or using VBA. Any direction would be greatly appreciated!