Sometime ago I wrote an article about updating MAC Addresses before (Convert MAC address in MS Excel or OO Spreadsheet) so the subject is not new :-). But this time I’ll try to explain how to Convert MAC addresses in MS Access. The standard format for printing MAC addresses in human-friendly form is six groups of two hexadecimal digits, separated by hyphens (-) or colons (:), in transmission order, e.g. 01-23-45-67-89-ab, 01:23:45:67:89:ab. In this article I’ll give you examples of how to add, remove or change the separator for MAC addresses in MS Access.