title: MS Access import and append type conversion fail on date field
body: <p>I am trying to import data from a text file and append it to a table in an MS Access 2010 database. All data imports and appends properly, with the exception of a date field. </p>
  
  <p>The date field is in the format: <code>yyyy-mm-dd hh:mm:ss</code></p>
  
  <p>I can import the text file into a new table without issue. This works if I specify the field as text or date/time with various foramts. Where it fails is when I try to append it to an existing table. It does not matter whether the destination field data type is text or date/time. </p>
  
  <p>It isn't the end of the world if I have to import the text file into a new table. But I find it very strange that I cannot import data form a text file to a text field. </p>
  
  <p>If anyone can shed some light on what is causing this issue I would be very grateful. </p>