I have several hundred tables in Access that I need to fix. Each mdb has the same tables and columns. For each mdb I have a table name ABC with a column ZYZ. I would like a macro to search through each mdb in a directory and change the values in column ZYZ to hold a value of 0 (zero) instead of a null. Can this be done through VB? If so how should I approach this?
On the same topic: if column MMM has a value of 12345678ABC and I would like to retain only the first 8 characters and drop the ABC, how would I do this?
Thanks
On the same topic: if column MMM has a value of 12345678ABC and I would like to retain only the first 8 characters and drop the ABC, how would I do this?
Thanks