Excel question: can this be done

[Steve Ignots]

I work at a fastener manufacturing company. We keep our customer order
records on index cards (customer, our part number, part weight, and,
every order, how many, sell price and order date). We've got thousands
of them in files. Sometimes they can't be found. They have to be
filed. Time to put them on the server.

Idea; so that we don't have to key in all the data already on the card
scan them (PDF?) and then paste them into the top of an Excel
spreadsheet. Put new data in the free columns/rows below the scanned
image. I tried it and all I get is a little box with a PDF logo in it.
Is there any way to put an image scanned from a document into an Excel
spreadsheet?

Thanks in advance for any and all suggestions.
Steve Ignots
CSM Fastener Products

 

[Dave Peterson]

Does your scanner come with Optical Character Recognition (OCR) software?

Lots of scanners do. This software actually converts the scanned image to text
(some can save as a word document, some can save as an excel file).

But I've never seen an OCR program that was 100% correct. You'd still have to a
manual check.

Once you get it to real text--not just a picture, you might be able to import it
into excel and clean it up nicely.

 

[arasu]

Steve,

Have you solved your problem? If not, can you answer couple of
questions for me? Depending on your answer, I may suggest something
that I use.

Are these the only fields that you capture on each card?:- customer,
part number, part weight, order, sell price and order date.

Were you thinking of one excel sheet per card? I am not quite clear on
how you were planning on using the pdf files (I assume that one pdf
document for each card - so a lot of files)

 

[Alan Cocks]

Why not scan as JPEG instead of PDF?

Steve,

Have you solved your problem? If not, can you answer couple of
questions for me? Depending on your answer, I may suggest something
that I use.

Are these the only fields that you capture on each card?:- customer,
part number, part weight, order, sell price and order date.

Were you thinking of one excel sheet per card? I am not quite clear on
how you were planning on using the pdf files (I assume that one pdf
document for each card - so a lot of files)


Dave Peterson <[email protected]> wrote in message