I am trying to import a text file in MS Access. All is fine except the most important field which is a date field YMD with a 4-digit year, leading zeroes and no / to separate. Example: 20081209
The date field yields a ‘type conversion failure’ and none of the dates are imported into ACCESS.