Data Clean-Up and Management

13

Data clean-up in Access

Abstract:

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

clean-up

sort

error

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