Importing Date Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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]
 
Back
Top