Cleaning up a Database

[Hanif Merali]

Hello,

I'm trying to clean up a customer data base mainly the name field and the
adress field to make sure the data can be machine mailable by a certain
standard. I was just wondering whats the best way to go about this. I was
thinking of writing a bit of VBA code to manipulate the data, I know how to
program and have used VBA before but I forget most of the syntax, does
anyone know a good website/book that could tell me all of the basic syntax
of the language as well as the classes w/ specifications that are available
to use. I just have ACCESS 2003/XP installed I'm not sure if I need to
download some more classes or what comes with the default package. Thanks
in advance.

Hanif

 

[Joe Fallon]

Data cleansing is usually best done with queries.
USe Left, Right, Mid and Instr to parse data into correct formats and then
update existing data or append to new tables. (Always work on a BACKUP copy
in case you make a serious mistake!)