What is data conversion?
Data conversion is simply the process of moving data from one place to another. Whether you are trying to convert data from an old application into your new Access application, or trying to export your Access data into other applications, data conversions can be a real challenge (read "pain in the butt"!).
- "Field Splitting" involves splitting data that is stored in 1 field in the old application into 2 or more fields in the new application. For example, a single name field (with format of "LastName, FirstName") might have to be split into 2 name fields ("FirstName" and "LastName").
- "Field Combining" involves combining 2 or more fields into one, which seems easy enough but can be tricky. For example, combining an Address1 and an Address2 into a single Address field must solve the sticky problem of inserting a carriage return between the lines, but ONLY if there is data in the Address2 field!
- "Data Cleanup" involves correcting those problems make data conversion difficult or impossible. Often due to poor data entry validations, these might involve invalid dates or invalid numeric data.
- "Field Standardization" involves converting variations of field values into a single, acceptable field value. For example, the list below shows a variety of spellings for just one city that I encountered when converting a customer database (not including the misspellings!):
St. Petersburg Beach
St. Petersburg Bch
St. Pete Beach
St. Pete Bch
St Pete Beach
St Pete Bch