Good day all.

I have an access application which reads a text file created by a telephony system.

This text file is comma separated, and its fields can be described as follows:

Number, Alpha, Number, Date, Number

The current application, reads the text file when an [Update] button is clicked and populates the required tables.

We are currently trying to program a "server" that would read the data every 10-15 seconds and populates the required tables automatically.

The problem I am encountering in this new "server" application is that I am getting "#Num" in the date field when I open the linked text file. I am really puzzled since the linked table in the original application displays the data correctly. Both link definitions are exactly the same, meaning: Number, Alpha, Number, Date, Number.


Help!

[LGuzman]

__________________
[LGuzman]

Found it. The system's date format must match that of the text table you are linking at the time the link is done.

(Just though I share the solution in case it happens to anyone else out there.)

:D

[LGuzman]