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 dates are imported into ACCESS. How can I get ACCESS to accept this as a date field?
I have googled it and only find that it would accept it if I went into the text file and added the slashes into the text file before import. Example: 2008/12/09
I do not know how to do that in an automated fashion.
The date field import into ACCESS yields a 'type conversion failure' and none of the dates are imported into ACCESS. How can I get ACCESS to accept this as a date field?
I have googled it and only find that it would accept it if I went into the text file and added the slashes into the text file before import. Example: 2008/12/09
I do not know how to do that in an automated fashion.