Linking to txt file from access db 2003 date error 1

[hsingh1981]

Hi All,

I can link to text file as table in ms access. The problem am getting is that the date comes up with an date error:

#Num!
#Num!
#Num!
#Num!
#Num!
#Num!etc in the date fields.


The format of the date is yyyymmdd e.g 20081106 in the text file.

i've seen another database that has link to this txt file and the date is fine. Which displays the database in dd/mm/yyyy with out any problems. Am not sure how my predecessor has done this.

cheers

Farouq


Can anyone help to

 

[DrSimon]

I suspect the link has been set up with a numeric data type rather than Date/Time. Try creating a new link and ensure that it's correct.
Simon Rouse

 

[PHV]

20081106 in the text file
No chance this value may be interpreted as a date.
But you can use a function:
DateSerial(Left(yourField,4),Mid(yourField,5,2),Right(yourField,2))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886