Best practices on cleaning data using VBA...tricks of the trade

[Pack10]

I will be moving on to another position in the next few weeks. I will be doing a lot of
data clean up, data coming from excel sheets....doing all sort of manipulations etc.
I would like to know if there is a document or something with all the VBA tricks on data cleanup.
IE...when you want to pad a field in access with an update query, or do it in excel.

 

[SkipVought]

Hi,

I'd do most if not all on the sheet.

First is Analysis. You need to figure out how to categorize the data by the cleanup techniques each category will need. There's no book for that.

I suppose that regex might come in handy.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}