Help with Importing Text file into Access

Hi All,

I have a large text file that is generated daily and want to import into MS Access via a macro or code. The issue is not all the segments are the same number of lines or they may have mutli message lines. The names with colon : after them I want to be field names in the table which I wish the text file to import into. Please, I am looking for assistance with this.

I have attached sample data of the text dump, and the name of the file is as you see but different date on the end. At the very end of the text file you will see the desired output after running the macro or code and then entered into table called TMessages

Also every new message begins with the dotted line and the date and time at the end.

I hope this makes sense to those offering assistance, if you have questions please ask them.

James Niven
Austin, Texas

see: http://www.excelforum.com/excel-prog...for-excel.html

James, going forward, if you need a thread moved PM a Mod and they will do this for you (if appropriate of course)