importing text file to access

  • Thread starter Thread starter mary
  • Start date Start date
M

mary

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
 
Hi Mary,

This sort of thing usually isn't too hard to handle with a little script
or a custom import routine, but it's necessary to know just what "other
garbage" appears in the file in order ensure that it won't stop the
script working properly. If you email me a sample file (remove the
anti-spam middle name from my email address) I'll take a look at it and
we can work out the best way to go.
 
Back
Top