import un-organised text to table

[mohsin via AccessMonster.com]

Hi

I have one log with multiple imformation, and need to import to seperate
table. the imformation base on command line name(example, ZRIL) and end with
command executed. Between the command line is the data which need to import
to table. Some of the data is un-orginised format, for example as below. So i
believe, need the vba to execute the jobs. But unfortunely i'm not very good
in this vba.

So if you have some hits or part of the vba struncture to extracted the field
base on command name, please share and very appreciate for your help.

thank you.
rgds - mohsin.

ZRIL:NDEST=MSS3; >>>>>>>>>>>>>>>>> command line

NAME OF DESTINATION: MSS3 DEST: 16

NAL TCR CNP PRI NL ADD IND PA IA EC
4 Y N ORD 0 N - N N N

MDC IARR
0 N

DESTINATION SSET = 0

SELO DSTATE PRESTR PPERC PSDEST PNSDEST PCHI
APD A ALT 70 - - -

ATTR(DEST) : - ATTN(DEST) : -


ALT SPCH QA DCA NSDEST SDEST SDTYPE SRESTR
0 0 N - MSS305 23 A S

CAT
A

ATTR(ALT) : - ATTN(ALT) : -


CHI: 2
CORG NCHA:
0 00003


ALT SPCH QA DCA NSDEST SDEST SDTYPE SRESTR
1 0 N - MSS304 22 A N

CAT
A

ATTR(ALT) : - ATTN(ALT) : -

CHI: 2
CORG NCHA:
0 00003
COMMAND EXECUTED