Type Conversion Error Importing text files to Access
Posted on 2010-01-08
I have a table defined with 5 different date columns. I have the date format set to yyyy-mm-dd. I need to import from a pipe-delimited text file which uses the same format in the text file, however when I try to import, I get Type Conversion errors for all dates in my file.
I suspect this has to do with a difference in how access stores date values vs. displays them.
Thoughts on overcvoming this?
Here are a few sample lines of data.
A|999999999|1900-01-15||ABCD|BASIC PRESCRIBED FIRE TRAINING|02|20|2008-12-06|2008-12-11|2012-12-31|NA|NA|0.00|05|04|48|0|05|03|03|0.00|0.00|0.00|236.00|236.00|NA
A|999999999|1900-01-15||ABCD|THE NSC 2009 CONGRESS & EXPO|02|20|2007-10-26|2007-10-27|2012-12-31|NA|NA|0.00|05|04|16|0|04|03|03|0.00|0.00|0.00|0.00|0.00|NA