Recent content by stirlsa

I have a similar problem trying to get a txt file with a YMD date field converted to a real date in ACCESS. I am glad to know that I am not totally crazy and that it is a known problem. I am now trying to do an ACCESS Update query, to convert the data. I am having syntacs errors. In design...

I am trying to import a 40,000 row 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 import into ACCESS yields a 'type conversion failure' and none of the...