I have data that is imported/dumped into my Access 2010 data base using the “dd mmm yyyy hh:nn” format. 95% of the data imported comes in with the hh:nn as 00:00 which is what I need. However, the remaining 5% comes in with random times, 09:54 or 22:11. Those random times causes problems down the line with my tables and charts. I’ve been editing that 5% manually for a long time. It’s time consuming and labor intensive. I’ve been trying to figure out a macro for just as long but cannot.
I’m not good with macros and looking for some ideas. I know date and times are taboo so I’m not sure if this is possible.
Thank you in advance, MP
Bookmarks