title: MS Access setting to ignore date conversion error
body: <p>An Access DB imports a fixed width text file; one column is mostly dates.
  When the date is not available, the file's creator actually uses the string "Null"
  Access puts the row in the table with that field actually null.</p>
  
  <p>But, when the files started coming with different field widths, I copied the DB, tweaked the starting/width values in the input spec, and imported.  NOW, all the rows with null get logging in (table)_import_errors as an error converting text to date.</p>
  
  <p>I have found no setting (not that I changed any) to explain it.  One difference is that although both DBs are in Access 2000 format, the original is on a machine that still has Access 2000, while the new one is being handled by Access 2003.  </p>
  
  <p>Is that a behavior change in the Access version?  Is pre-processing the file the only solution?</p>
  
  <hr>
  
  <p>Thanks, David.  That's what I would have done (except for the Excel part) if it had not fixed itself.  I posted that, but apparently someone didn't like the public admission that Access has bugs.  </p>
  
  <p>The only thing that changed was that two  <em>other</em> columns in the fixed width plain text input was wider.  Yet Access "decided" to discard the whole row instead of just the date field for three consecutive attempts.  The fourth time, it still reported it as an error but imported the rest of the row.</p>
  
  <p>So, when Access misbehaves for no good reason, try again a time or two, then try explicitly coding the conversion from text.</p>