Importing Date Problem

[Guest]

I'm importing data from a text file and the date is shown as 040207. I've
set my table I'm importing to "short date" format. When I do that, the date
does not import. Is there some other way I can convert the date to be the
short date format 4/2/2007 in my reports if it is shown in my table at
040207? Thanks in advance for your help.

 

[John W. Vinson]

I'm importing data from a text file and the date is shown as 040207. I've
set my table I'm importing to "short date" format. When I do that, the date
does not import. Is there some other way I can convert the date to be the
short date format 4/2/2007 in my reports if it is shown in my table at
040207? Thanks in advance for your help.

I'd suggest *linking* to the text file (rather than importing); run an Append
query to append it into the target table. Use a calculated field

CDate(Format([textdate], "@@/@@/@@"))

to convert the text string to a Date/Time field.

John W. Vinson [MVP]