importing unformatted .txt file date field into MS Access

By stirlsa ·
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 conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums