Import Text file

[Dean]

I have a text file that is created each day by a program, I wish to import
this into a DB. Is there an easy way.
1st problem is that the file name is textdate.txt where text is a filename
that is constant)
date is obviously the date of the file but it is in the format of
07.07.2004, this is not importable by access!
Next problem is that the first three lines of the file are always the same
and will not be needed, (junk text).

File directory is constant
file length will vary
I have previous experiance of VBA and importing text but not this.

Can anyone soggest a short simple query that I can use?

Thanks in advance
Dean

(e-mail address removed)

http://www.dkso.co.uk/

http://homepage.ntlworld.com/dkso

 

[Peter Jay Salzman]

If I were faced with this problem, I'd write a short perl script to do
this. Perl is very good at this kind of thing (although any programming
language would do), although I don't have any experience with Perl on MS
Windows.

Pete