Scanning documents directly in to MS Access

[aboulton]

Is it possible to scan documents directly in to MS Access and store them in a field in a table please??

If so how??

Thanks for your help

 

[Banana]

Not direclty, I'd think.

Look around for a OCR software to harvest text from scanned documents, save as text file then create a VBA procerhure to read the text from the text file and add to record.

This is of course, assuming all scanned document are exactly identical. If they are not, you're asking for a custom VBA procerhure per document which at this point, may be just easier to enter data yourself.

Forgot to add-

If the documents are hand written, you might as well forget about it. Not going to work. OCR software have enough trouble correctly recognizing typefaced characters and filtering out noise produced by the scanner (high quality scanner usually helps in this regards).

 

[mousemat]

What sort of documents are you scanning? and what purpose is this for.
It can be done im sure, but its a bit like re-inventing the wheel.
There are far better software applications for the purpose of scanning document, storing the tif file and searching the database for a particular scanned document.

I use Alchemy for my scanning and document retrivial business - have a look at my website