I am working on some text files   that I will need to
import to access. However, before I can transfer the data
I will need to filter or clean up the data to leave only
information that I need. In the past, I was able to use
excel to clean up the information and record a macro that
does the cleaning process. I think I need to create a  vb
script but have no idea how. This is how the text data
looks like with some other garbage like "/", "pas","-----
": Anyone that does scheduling, this is the adherence
report from IEX. I already have a module that imports the
text but it does not clean up the text. It just collects
the text file and load it to a text box with it path.
Data imported:
ID           NAME    
2323      PUAL
                 -----Scheduled-----              
Scheduled
From    To    Duration      Activity
06:00  07:45  01:45       start
07:45  08:00  00:15          break
10:30  12:30  02:00       sick
Table that will be import to with 3 columns.
ID     Activity       Duration

I will like to capture the id which is my primary key
and Paul sick activity as well as it duration. I know
this is hard but any help will do. The wizard in access
will not do. I have created a specification but it does
not arrange the data like I will like it to. I do not
even clean up the data.
Thanks in advance