importing unformatted .txt file date field into MS Access - TechRepublic
Question
April 10, 2009 at 03:03 PM
stirlsa

importing unformatted .txt file date field into MS Access

by stirlsa . Updated 17 years, 3 months ago

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.

This discussion is locked

All Comments