Import Conversion Failure

[Rick4077]

This happens with Access 2003 so often it's not funny!

Type Conversion Failure	| LISTDATE |
Type Conversion Failure	|STATUSCHANGEDATE |

The date in the imported text file is as: 2000-06-20 00:00:00

Any ideas?

Thanks . . . Rick

 

[JerryKlmns]

Maybe you should check the date format while importing in your
Advanced settings {Import Specification] to define
Date Order YMD
Date Delimiter -
Time Delimiter -

save the spec and use from here on

 

[JerryKlmns]

Oops

Maybe you should check the date format while importing in your
Advanced settings {Import Specification] to define
Date Order YMD
Date Delimiter -
Time Delimiter : <--That's the correct

 

[Rick4077]

Thanks for the suggestions. I haven't done that yet. I probably should.

What I did was change the field format to text in lieu of date and this did the trick.

However, I would like to try the date order and see what I get.

Thanks again . . . Rick