Can Ms Access Read Scanned Data?
Is there a way Ms Access can capture data through scan, for example if an invoice is coded expense then in the field for cost type it should write an expense.
I think there is an opportunity to do away with routine bookkeeping by using VBA code as long as MS access can read the scan, I can for see non-accountants doing complete booking keeping & consolidation of accounting statements on their own without knowing what is in the background. I think the only cost here is buying a scanner.
Regards
Chris
I think there is an opportunity to do away with routine bookkeeping by using VBA code as long as MS access can read the scan, I can for see non-accountants doing complete booking keeping & consolidation of accounting statements on their own without knowing what is in the background. I think the only cost here is buying a scanner.
Regards
Chris
What I mean here is that in most shopping malls they use scanners to read the product codes , those are the one I'm talking about , can that information be captured in Ms Access via some fields?????????????
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks
If by "read" you mean convert a scanned image to text or numbers so that you can work with them, no, nothing like that is built-in. OCR (Optical Character Recognition) is very involved. Most scanners come with software that does that for you, but very often not with great success. Then once you have it, you need to figure out what all the data is, which can be difficult as well. In short, it never works well unless it is a predefined form that your aware of and know what it will look like.
If you mean work with a scanned image as an image and store/display it, then yes you can do that with Access.
Jim.