Reading Word Documents (1 Viewer)

[TopQuote]

I have a folder containing 800 word documents. These documents each contain a unique 6-digit alphanumeric number.

I would like to read through the document, line by line, find this number, then create a new record in an existing table containing the document name and the 6-digit number.

Any help would be great...

 

[Fizzio]

How I would approach this is to

- count the number of files in the folder
- create a loop based on the number of fields
- open each word document in turn
- copy the text into a variable in access
- search for the 6 digit number (can it be any 6-digit number or a specific?)
- if match, add to the recordset either the document name or a link to that document.
- move to next document

If you search this forum, you will find code that will allow you to do all of these things but post back if you get stuck. You will need to use a mixture of VBA in access and word to acheive this.
Happy hunting!