I have a table in MS ACCESS with a field Name STATE.
I need to update all the state field values to match with the list I have.
Connecticut should read as CT
North Carolina should read as NC
Indiana should read as IN
Massachusetts should read as MA
I have all the distinct state values. If someone could help with the sample above that will be helpful