If you’re attempting to import times into a Microsoft Access database (.mdb) it’s important to realize that it will only work if the data is in 24-hour format (example: 13:52:09). Times including the “AM/PM” portion will generate type conversion errors, even though they’re a valid format…in just about any other scenario.
Thanks Microsoft… *sigh*