title: Convert a string to a date in Access
body: <p>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.</p>
  
  <p>I want to store the field as a datetime in the new table.  I've tried using <code>CDate()</code> in my SQL statement, but it just displays as <code>#Error</code> in the results.</p>
  
  <p>What am I doing wrong?</p>