IMPORT date from text file

[Lucio]

I have a text file that contains a field of the type 'dd-mmm-yy'

When I import, it notices it is a date/time field

It does not load. It returns a conversion error.

also another question.

suppose it loaded. how do i write SQL of the type

created > '01-jan-06' and created < '01-jul-06'?

 

[Dale Fye]

What is the data type of the field in your database?

How are you importing the text file? Are you using an import specification?
If so, have you explicitly declared that the field is a date field? What
does a row of the input data look like in the text file? Are the fields of
fixed length, or delimited? Are the dates wrapped in quotes or not.

I created an mdb and put a date field in it, then created a text file with
dates in the format you indicated, and they imported properly when I used an
import specification but gave me an error when I tried to do it without using
an import specification.

HTH
Dale