Access 07 import yyyymmdd

  • Thread starter Thread starter tg
  • Start date Start date
T

tg

I have been trying to import a text file to access 2007 and I keep getting an
error. I looked online and noticed that it is a problem with access not
recognizing the date format yyyymmdd. In order to get around this, I have
had to import to Excel, then import the spreadsheet to access. I was hoping
someone might know a fix, or if Microsoft plans to patch this little problem.
Thanks.
 
One approach is to import the date field as Text, and then run an Update
query to convert the Text date to a real date and update a Date date field.

UPDATE MyTable
SET MyDateField = CDate(Format([MyTextDateField], "####\-##\-##"))
 
Back
Top