Document File content searching

[Savil]

Hi all
Could someone please give me an example of how to do a keyword search on an OCRd PDF or Word document contents and return the successful matching file names

This is not to search the filenames but the document contents.

Thanks in advance

 

[HarleyQuinn]

What version of Access are you using?

HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.

http://lessthandot.com

 

[Savil]

2003 but could upgrade if necessary!

 

[HarleyQuinn]

As long as you don't upgrade I'd suggest that Application.FileSearch could achieve the results you want.

This isn't available in 2007 (though I hear rumours that eventually somone here will be posting a version that can be used in 2007)

HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.

http://lessthandot.com

 

[Savil]

doesn't application.filesearch search for file names in a given folder or can it do what I want and open all files in the given folder and search inside the documents for a particular word?

Need it for Word and PDF documents

 

[HarleyQuinn]

It can search in the documents for a word.

Have a look at the MatchTextExactly and MatchAllWordForms properties of the FileSearch object.

Hope this helps

HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.

http://lessthandot.com