Type Conversion Failure

[Guest]

I have data that I am importing from a csv file. This data includes a number
of fields that are dates. I'm having trouble with just one on those fields.

All date fields import properly except for one. The one that does not work
produces an error table and the import on this field is not working due to a
"Type Conversion Failure". As I said, all other date fields import just fine.

Here is the interesting part. If I open the csv file in Excel, the date
field is there and correct. If I look at the field during the import set-up,
the dates are in a format that looks like 2004-08-27, where the other date
fields are properly formated. Actually doing the import causes the field not
to be included and the creation of the error table.

I am confused. Why is this one field having an import problem?

Thanks

 

[Jeff Boyce]

Dan

Another approach (i.e., work-around) might be to import this one trouble
field as it is (sounds like a text/character field). After import, you
would use an update (or append) query to convert it to a date that Access
recognizes.