I've recenlty been tasked with updating a field in a table, Class Code,from an excel spread sheet. The Source is an Excel doc which has a duplicate column that holds the updated information. This Column needs to be merged with the field in the Class Code Tbl. There are blanks in Class Code Tbl. that need udating.

In my first attempt i imported the excel doc. into access. i then created query bringing in both tables and linking...