Opened the workbook, changed nothing.
Date and USA Date columns are identical, except USADate shows 2-digit year: 5/13/2023 and 5/13/23.
Both columns show they are formatted for U.S.
Opened the workbook, changed nothing.
Date and USA Date columns are identical, except USADate shows 2-digit year: 5/13/2023 and 5/13/23.
Both columns show they are formatted for U.S.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I might have just selected mm/dd/yy for the USA format.
However you should be able to change column A to be English date format?
Then try and import.
Edit: Yes, I can see from the pic in post #9 that is the format. That is just what Excel presents in the dropdown. One can sill specify mm/dd/yyyy as custom?, however two digit year should be fine. Just a format after all?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba