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.

Key words




subscript out of range

type conversion failure

input mask

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 ...

Get Data Clean-Up and Management now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.