Grabbing parts of a TXT file to add to a table

[AC5FF]

This may be the wrong place to put this and if it should be in another forum please let me know.

Years ago I used to know how to do this but that knowledge has left me and the database I was using at the time no longer will open (corrupted/etc ... I don't know)...

I have a report that is generated daily that is a TXT file that is also the has the same file name each morning. One section out of this file is needed in a database that compiles and sends out reports to our customers. This section of the TXT file is variable in length, but is always preceeded and ends with a specific text string that I can search for. It is also formatted in columns that are always the same width.

I currently have to hand enter this section into the database every morning. Not the easiest of tasks... I would like to get this automated. Does anyone know of a walk-thru on how I can accomplish this??

Thanks

 

[AC5FF]

I love posting here!
Half the time after I do a post like above I find the answer I needed someplace online.
I've got a little work to do now to strip my table of unwanted data, but other than that I've got it......

Thx