I am trying to analyze trends in data stored in multiple (~400) MS Word .doc files. The MS Word 8.0 files have formatted text as labels and embedded (pasted) Excel worksheets used to store and perform simple calculations on the data.
We currently use an Access Database to store our data, but I...