This video explains how to fix the conversion failure issue, when importing .csv file into Microsoft Access database with Date/Time field.
0:00 Intro
2:35 Solution 1: By changing Date/Time to ShortText data type
4:10 Solution 2: By converting Date format from Windows settings