Hi:
Just wanted to add an issue that I also came across with text-to-date conversion in Access 2000.
Date in imported txt file is ddmmmyyyy (where "mmm" is alpha, like AUG)and Date needs to be formatted as mm/dd/yyyy.
I created an Update query that looks like this:
Field: Text...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.