J
Jim Clark
I receive a large number of records as a single multi-page msword document.
I can only print each of those "pages" at this time. I need to work with
these records, alphabatize them, etc. before printing them out. It now takes
@ 2 hours just to manipulate the paper to get it into proper sequence. The
records all have commonality in that each has "patient name" "date of
service", etc. I have found a macro that will break up the multi-page doc
into single files. Some of the records are 2 "pages" in length. If
necessary, I can combine files where records are more than 1 "page" in
length. Since these records contain a considerable amount of body text, it
seems to me that it would be more prudent to work with the data in the word
files instead of importing "all of each file" into an access database. It
makes more sense to me to set fields (ie. something like - begin at space 41
in the doc and go to the end of the first word to begin, and end at the end
of the second word, etc. It should get you the last name if you are using
the "Patient Name" illustration above, and next, the first name, etc. I do
not know how to import this information into an access table. (I am
thinking in terms of 'first name', 'second name', 'date of service' etc. as
fields in a table - linked to the individual word documents.)
Alternatively, it may be much simpler to import each word file into an
access table and work with it from there. Regardless, I need to create an
access database with fields in tables from each of those records so I can
work with and manipulate those records.
Any general or specific advice will be greatly appreciated. I have
some experience working with ms access 97, but am not proficient in coding.
Thanks,
Jim Clark
I can only print each of those "pages" at this time. I need to work with
these records, alphabatize them, etc. before printing them out. It now takes
@ 2 hours just to manipulate the paper to get it into proper sequence. The
records all have commonality in that each has "patient name" "date of
service", etc. I have found a macro that will break up the multi-page doc
into single files. Some of the records are 2 "pages" in length. If
necessary, I can combine files where records are more than 1 "page" in
length. Since these records contain a considerable amount of body text, it
seems to me that it would be more prudent to work with the data in the word
files instead of importing "all of each file" into an access database. It
makes more sense to me to set fields (ie. something like - begin at space 41
in the doc and go to the end of the first word to begin, and end at the end
of the second word, etc. It should get you the last name if you are using
the "Patient Name" illustration above, and next, the first name, etc. I do
not know how to import this information into an access table. (I am
thinking in terms of 'first name', 'second name', 'date of service' etc. as
fields in a table - linked to the individual word documents.)
Alternatively, it may be much simpler to import each word file into an
access table and work with it from there. Regardless, I need to create an
access database with fields in tables from each of those records so I can
work with and manipulate those records.
Any general or specific advice will be greatly appreciated. I have
some experience working with ms access 97, but am not proficient in coding.
Thanks,
Jim Clark