Questions about importing text data

[greaseman]

I've got a really wacky text file that can contain a ton of verbiage, followed by several rows and columns (almost looks like Excel data), which in turn is followed by a bunch of verbiage, another several rows and columns of data and so on. Incidentally, the row and data portions of the text file can span several pages, which means that in between the data from the data's first page to second page can be additional verbiage.

I am only interested in the row and data portions of the text file.

I have attached a small zip file that shows how the data can appear.

My questions: How might I plow through the text file, extract only the row and column data portions and save each of the data portions into separate Access tables? Also, for those portions of the row and data segments that span pages, I want to obviously keep those segments in the same Access table.

I'm thinking I should use some kind of a loop within a loop, but just can't wrap my head around the headaches I'm running into.

Anyone willing to offer advice, help or comments? I would be most appreciative for any and all replies.

Thanks!

 

[KeithG]

There is a program called Monarch that you can purchase to modify the format of the data. I can run your text file through it to give you an example.

 

[greaseman]

KeithG,

Thanks! I've heard of Monarch and used it several years ago. If you would be so kind, yes, please run my sample txt file through your copy of Monarch.

I'd love to see what the output looks like, and thanks so much!!!

 

[JoeCruse]

g'man,

I had a similar situation to deal with not too long ago, but the text file was not nearly as big as yours. Here is the post:

http://www.access-programmers.co.uk/forums/showthread.php?t=83493

Wayne Ryan gave me a great solution for tackling this, and I just adapted it to what I had to deal with. All credit to him. Maybe it can help you.

 

[greaseman]

Good morning, JoeCruise.....

Thanks for the suggestion! I've made a copy of your code and will be mod'ing it to see if it'll do what I'm interested in trying. I think my hardest part will be when I'm spanning pages in my txt file, but will dink around with it and see what falls out.

In any case, I appreciate your offer of help.

 

[KeithG]

Here you go Greaseman, I ran your text file througn Monarch. This is just a quick example so I don't know if the formatted text file is exactly how you need it. But I wanted to show an example.

 

[greaseman]

KeithG,

Thanks!! That is pretty close to what I want. Does Monarch offer a time-limited or record-limited copy of their software? I couldn't tell when I looked at their site. What about cost for a single copy license?

I appreciate your help! Thanks!!

 

[KeithG]

I am not sure how much the licensing cost. Like I said that was just a quick example so I am sure you could get the text file formated correctly.