Extract Data from a Word Document

[Cotty42]

Hi All

Not sure if this is possible but I am trying to extract data from a word document to set up a database.

Basically I am trying to capture data from completed forms, similar to the sample attached, the actual blank form is 20 pages long and once completed can be as many as 30 pages, or even more, although the format doesnt change (i.e. individidual cells will expand to fit the data in the cell).

I want to be able to scan through the completed forms and extract the data i.e. Full Study Title, Short Study Title, Study Type etc. into a database.

The issues:
1. Each document will have a different name but will be stored in the same location.
2. What is on page 8, for example, in one document is not necessarity going to be the same on every document (due to expanding cells)
3. Each sector is in a separate table but tables can spread across several pages.
4. Some data is stored in a checkbox format rather than text.
5. I dont want to extract all of the data, only certain sections (at least at this stage).

Any help from the guru's will be very welcome.

Thanks

Dave

 

[vbaInet]

It should be possible but you should be asking in an appropriate Word forum.

I believe there are ways you can set up a word document to have it linked to a data source so that any documents that come through can be uploaded directly to the source without any human intervention. Only the Word VBA guys would know this.