A co worker at a client had trouble importing textual date strings into Microsoft access.
Since many databases like yyyy-mm-dd as a universal import date format, I suggested trying that and searching for some backing on the Internet.
Indeed this StackOverflow answer confirmed my gues.
–jeroen
Via: vba – Parse data and time string to Access Date value – Stack Overflow.





