I have some tables with many records that need to be normalized. When
I use the table analyzer wizard, it appears to read and attempt to
match on only the first few characters in a field, and I'm presented
with hundreds or thousands of erroneous "typos" that Access97 wants me
to either correct or select "Leave As Is" in each record.

Is there a quick way to reset all these errors that Access has made
and take the values as they exist?

TIA,
Dale