How to scan the document and store in access in a shot

  • Thread starter Thread starter R.D.CHETTY
  • Start date Start date
R

R.D.CHETTY

Hi all
I have lot of documents to be scanned and stored in the
database. But I want everything to be done in one click of
button.

Is there any way. I have latest scanner and Access .

Thanks in advance
 
RD:

Never store an image directly in your database it will cause severe db
bloat. Only store the file path to the resulting scan image in your
database.

As to whether you can automate scanning, that really depends on the scanning
software you are using. If it supports COM automation (i.e. exposes an
ActiveX interface) then you might be able to automate it, but most of those
programs that come with scanners are pretty light weight and its doubtful
that it exposes such an interface. Check with your scanning software
manufacturer.

I've never played with it but Office 2003 does include Microsoft Document
Scanning as an add on program and it may support automation.
 
Back
Top