A few years ago, I used an ACCESS add in program that allowed for quick data normalization within the DB. A few clicks and a new column of data was created - no dashes or other symbols or unwanted characters.
Can anyone suggest an ACCESS add in that would allow for simple data normalization - on a large DB with close to a million records???
Thanks