Browse Word document for values in database

A

Amanda

Total newbie here.

I want to scan a Word document (or dump all the text into a comment field in
my database if that'd be a lot easier) to find words that are contained
within my database. If a word is found to be in the database, I'd like to
put it in a list.

Any suggestions?
Thanks, Amanda
 
J

Jeff Boyce

Amanda

I'm having trouble visualizing what you have and what you want to do with
it.

What database? Can you describe it a bit more?

"Put in a list" ... where?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
A

Amanda

I am a reading tutor and have a database of almost 6,000 words with different
levels of difficulty (Wilson substeps) and types (regular and irregular). I
would like to write a passage in Word and then scan that passage (perhaps in
a Memo field within the database) to find all the words in it that are in the
database and send them to a grouped list (grouped by substep most likely).

I might be able to do this just within Access, through the Lookup data type,
but I'm not sure. Since posting my question, I found something in the Help
section entitled "Create a field that looks up or lists values in tables". I
think it's what I want but I'm not sure and haven't had time to see if I can
get it to work

Thanks for your help.
Amanda
 
A

Amanda

The "Create a field that looks up or lists values in tables" in Access help
wasn't at all what I wanted.

Any suggestions?

Thanks,
Amanda
 
J

Jeff Boyce

Amanda

I don't have any direct experience with something like this, but I expect
other newsgroup reader do...

If I were taking on a project like this, I might resort to building a
procedure in VBA to cycle through each word in the passage, identifying its
substep & type, adding a count of 1 to a (temporary) table (I'm guessing my
PC might run out of RAM if I tried to use an array) in the appropriate
"category", then running a query against the (temporary) table to get the
"grouped list".

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting URLs in comments to Markdown-formatted links 2
Working on birthday "book" for my wife and having layout/editing trouble 0
Finding the proper style field and the numbered paragraph value within the style 0
Import data from excel 1
automated Glossary creation in Word 0
Read text from Word Documents, allowing for Field Codes, Tables,Shapes etc 0
Upload Word document 0
Word Macro for multiple searches, incl. in footnotes 2

Top