Hi all, I've searched this forum quite a bit and haven't found anything
to assist me in what I am trying to do.

We are FTP'd at various times 2 files to be 'imported' into a SQL
databse. The .txt file contains the record that actually needs to be
entered into the table the other (a .pdf) just needs to be copied to a
sub-directory on the server (which is not a problem).

Here is a sample of one of the text files;

A 1141173132 9518453813 2006-08-07 CA
VOL ADJ

The first line is 5 space delimited entries, the second line is a
single entry (up to 80 characters). I beleive their is a CRLF between
the lines.

My question is what is the best way to import the record out of the
..txt file?

Thanks you in advance for any help in this matter.

One thing I forgot to add is I want to be able to import these
automatically. That is have a 'job' of some kind that runs hourly (or
whatever) and imports any of the files that are on the FTP server.