This should be a relatively simple project for anyone with VBA experience. Given a Word document, extract blocks of text (always beginning with WORD1 and ending with WORD2) and send them to a table in Access.
The code will need to be run again in 6 months, with a new word document, but appending the results to the existing Access file (so it may be helpful to prompt the user for the specific word and access files to use)
See attached word file. I need extracted to Access: CASE NAME, PRIOR HISTORY, DISPOSITION, CASE SUMMARY, PROCEDURAL POSTURE, OVERVIEW, OUTCOME, & CORE TERMS (bonus points if each of the core terms are easily query-able)
