converting word doc to access table.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can receive individual medical records in an ms word document, each record
being a page or two. I need help in taking these records (usually 100 +) and
separating them, putting them separately into a table and creating fields .
ie. "Patient Name", "date of service", etc.

Thanks in advance,-
Jim Clark
 
Hi Jim,

If the structure and/or layout of the Word documents is absolutely
consistent it's usually possible to extract the data under program
control. Otherwise it's usually quicker to re-enter the data manually
than to acquire the programming skills and write and test the necessary
code. Questions:

1) Is each record a separate Word document, or can one document contain
many records, each a page or two long?

2) How are the records laid out in the Word document(s)? E.g. in Word
form fields, in Word tables, free text, CSV...

3) Does every record have the exact same layout?
 
Back
Top