Convert A String To A Date In Access

I'm migrating data between tables in Access 2003. In the old table, the date was stored as a text field in the format YYYYMMDD. I want to store the field as a datetime in the new

Solution 1:

e.g. cdate(format("20091231", "####/##/##"))

So, in your case it will be

SELECTcdate(format(mystringFieldThatIsInYYYYMMDDFormat, "####/##/##"))   
FROM myData