MICHAED
asked on
Scanning a doc into Access....
I'd like to scan several documents containing various info (ex: Name, S.S.N., Loan#, etc...)into an Access table. The info in each doc are in columns. I'd need to do this roughly 10 times a month.I was considering opening it in Excel...then importing to Access. Also, I was considering creating a template in Monarch. Any suggestions ?? Please let me know if more info is required...I will adjust points if necessary....Thanks in advance.(By the way...my scanner is an HP Scanjet 5200C
ASKER
Edited text of question.
Hello.
I guess the first question, and most important is... where is the data in the sheet you're scanning coming from? Obviously on your end getting the data in electronic (rather than paper) form would be highly desireable.
After that, are you anticipating running the scan through an OCR first, or did you plan on doing that within access?
I guess the first question, and most important is... where is the data in the sheet you're scanning coming from? Obviously on your end getting the data in electronic (rather than paper) form would be highly desireable.
After that, are you anticipating running the scan through an OCR first, or did you plan on doing that within access?
ASKER
We hope to receive electronic data in the future....but I have roughly 50 docs that has info I'd like to scan...rather than manually input.How do you mean...OCR ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If the documents you are scanning have formatting, OCR won't help too much.
Then you would be looking at adding OLE objects to your database. Those could be a GIF, JPG, or BMP image of the scanned page; or, it could be a link to an MS Word or Excel document.
OLE objects in your database are handy, but usually take up a lot more space.
Jim is right (as usual) that if you can convert the scan to a flat text file, you can import it easily into MS Access and go from there..
Then you would be looking at adding OLE objects to your database. Those could be a GIF, JPG, or BMP image of the scanned page; or, it could be a link to an MS Word or Excel document.
OLE objects in your database are handy, but usually take up a lot more space.
Jim is right (as usual) that if you can convert the scan to a flat text file, you can import it easily into MS Access and go from there..
ASKER