I have over 4100 documents that contain data that I'd like to extract and put in an Access database. Each Word document represents one data record. The Word document stores roughly 30-40 pieces of information about one unique hose. Each hose has a unique ID and then contains information about its outer diameter, hose length, operating temperature, operating pressure, maximum pressure, material being transferred, type of end connectors, etc.
I'm trying to determine if there is a way to search the table within the Word document for its key characteristics. That data would then have to be imported into my Access table. I'm assuming this program or routine would have to be done one at a time for each of the 4100 documents. I'm not sure the best way to do such an operation.
Here is a suggestion from boag2000; Rank: Genius:
The only way I think you will be able to "isolate" the Data is to somehow use code to determine if a section of the Row line is Black, (meaning it is underlined and contains the Data) then take the text above it as the Data.
(After that, it will be a simple matter to remove any trailing or leading spaces.)
To that end, ...you can close this question and post this suggestion as a new question in the Word Zone.
JeffCoachman
==========================
==========
==
You can find an example Word document in a previous question located here:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Word/Q_24825298.html
