Data clean-up in Access
Common scenarios for dirty data in Microsoft Access are presented, with possible solutions. Emphasis is on cleaning data before it is loaded into Access. Input masks on specific fields are another solution.
subscript out of range
type conversion failure
For librarians, clean-up issues in Access usually mean dirty data from an Excel spreadsheet was loaded into Access. Sometimes, no matter how much time was put in, or how many ways one looked at the data, errors requiring clean-up creep in. With the sheer volume of data passing through a library, dirty data is bound to get in.
Prevention is the best cure
We’ve spent much time going over the data, but dirty data ...