Question Locked

importing unformatted .txt file date field into MS Access

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

2 replies

by maevinn

Create a custom field, since that is not a standard date format in Access.

Or, import it to a string field and then convert it to a date field.

This discussion is closed to new replies.