Unanswered: importing txt file, access cant convert a field to date
I am importing a .txt file in delimited format. There are a couple fields that are dates in the format 010191, as in Jan 1, 1991. When I try to select Date/Time as the data type, I get "type conversion failure." Is there a way to convert this to date without use of VBA? My coding skills are very lacking... .
I have tried this with an existing table and importing a new table and both work.
The key I believe is that when you go thru the import wizard, select the advanced button and delete the / in the Date Delimiter and check the Leading Zeros in Dates.