Scan Pictures In excel format

L

Limited505

New Member
Hi.

I've got this huge book of about 50,000 contacts that I'm trying to save time on by simply uploading it to and excel document.

I know I need to scan each page individually but from there I'm lost. I've tried to find out from a couple different places how to do this but so far have come across nothing that really works.

My end product I want is that each of these contacts is in a separate cell in excel.

How can I do this?!?!

Someone please help cause if I can't figure this out, I have about four months of data entry I need to pay for or just do it myself and that would be such a waste of my time and money.

THANKS!
 
What do the contact sheets consist of? Are you talking about sheets of paper with multiple thumbnail pictures? Describe size and make-up.

If each is a moderate scan, even 1024x768 pixels and you plan to put each contact in a cell, it will be a huge spreadsheet. What is the end use of this? Excel is not a graphic application and highly unsuited to large numbers of large images.

You have to think in advance of how on earth this document is going to open. This could be a several hundred megabyte or a few gigabyte spreadsheet.
 
It is a book of pure contacts, address phone number email and such. I want to scan each page into a computer. I want to turn the photo of the page into an excel spreadsheet that just has the contact information. I know that this would be an extremely large document just for a basic data base of mine so I can refer to this for contact information.
 
I haven't played with a lot of features in years. One thing like mentioned it would be huge. Im thinking Microsoft Access would do a lot better. Not to mention a thousand times faster if searching. It would be right now. No wait state like Excel. Access is a great database ive played with before.
 
Your proposal is very wasteful of resources. You are basically interested in text, not images.

How do you intend to catalog these? You have to have a system to find a particular "card". If you really want to use the scans, use Explorer. You scan each page and give it a name, "A.B.Smith.jpg" or whatever. Put the images into a folder (which could be subdivided such as regional location, company, whatever). To retrieve info you double-click the jpg file and it appears in your default graphic editor.

Depending on the quality, you could also consider scanning with OCR. Convert all the pages into actual text. Then you can stick it where you like, no images. I have not found OCR to be that good but it depends on the quality of the original print. Unfortunately you usually have to check the results. To save doing that, you could scan doing both OCR and saving as a jpg for the record. If any OCR text data proves inaccurate in the future you could dig out the jpg.
 
You must log in or register to reply here.
Back
Top