Fixing Date/Time import error in Microsoft Access (Avoiding conversion failure error)

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

[maraoneill]

For years I had a weekly data import that included date fields. A new date field was recently added that I could not pull it in. To compound the mystery, the old date fields were still importing fine (unless I manipulated them). Your video solved the problem and saved my sanity! Thank you Nuha!

[kashifali]

You're a genius !! Thank you very much for providing the explanation for this type of error !! And thank you very much for providing the solution!! Greatly appreciated !!

[mtpresearch]

Superb.. thanks, you've solved a great issue, i was struggling to solve since long

[rajeshkurna]

Special thanks for you ma'am.
For making my students understand the error and solve it easily.
Your explanation is cool ma'am.

[femina]

Omg thank you so much I was struggling a lot and after watching your video I finally solved the issue ❤

[HninNandar-fuvi]

Wait we need to change the MDY or DMY like those in advance!! It isn't