Format Text file for Excel

[bigroo1958]

Hi All,

I am thinking maybe I should work on this file in Excel and then import into Access, so I am moving this post/message from Access Programming to here, so I hope I am not breaking any rules.

I have a large text file that is generated daily and want to import into MS Access as the end result.

First I need to reformat into the row format in excel rather than the format it is in. 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 which I will then import into Access

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