Data Extraction from MS Word

  • Thread starter Thread starter KenB
  • Start date Start date
K

KenB

I have data from a clinical trial, where each record has
been stored on a network drive in (of all things) a MS
Word document. The documents were created with a
template, so the location of the data within the document
should be consistent. The question is: is there a way
for me to extract the data out of a document so that I
can send it on to a real database?
 
Yes, Import System.Runtime.InteropServices

Then add a reference to the Word Library you have one your local machine.
Word 9.0 for instance.

Then, you can walk the network drive open the docuement and use either
Word's Find method, or grab all the text and parse it with a Regex.

You can even record a macro to get you through finding the code to do
this...

HTH,
Bill
 
Back
Top