Scanning Documents To Get Counts

[Learn2010]

Once a year we have a conference that has about 400 people attend. These people will participate in several classes, randomly, over a four day period. Each class hands out an evaluation form. This form has six categories and asks you to rate each from 1 to 5. This is done with a grid on the form labeled with 1 2 3 4 5 across the top and the attendees will put a checkmark or X in the appropriate box. This results in approximately 3000 evaluation sheets.

I will take these and manually enter the scores into a database I created in order to tally the results and generate reports. I have been asked to see if this process can be expedited by using a scanner to pull the scores from the sheets.

Has anyone done this, or know how to do it? Thanks for your help.

 

[Mihail]

Very interesting provocation.
Can you upload few scanned documents ?

 

[Learn2010]

I don't have any scanned documents. I am looking for ways to scan and get the data.

 

[Learn2010]

I don't have to scan into Access. I can scan into Excel, or ?, and import to Access. Does that open up any thinking out there?

 

[contractor]

Hi,

Maybe this link will help you to get an idea http://www.vbaexpress.com/kb/getarticle.php?kb_id=1101

contractor

 

[Learn2010]

I will have about 3,000 sheets. Everything I have seen thus far seems to be for one sheet at a time.

 

[Mihail]

I don't have to scan into Access. I can scan into Excel, or ?, and import to Access. Does that open up any thinking out there?

I think that a .jpg is the best for me (us ?).
My idea is to use Abby Fine Reader (is the best I know) to translate in other format.

I'm very sure that you should use a "template" when you scan: always use the same position for paper sheet on the scanner plate.

But... 1000 words = nothing until I have some scanned documents (I repeat: JPGs or other pictures format)