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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.