ARCHIVES-L Archives

Archiver > ARCHIVES > 1999-04 > 0924018983


From: "Lee Zion" <>
Subject: Re: [ARCHIVES-L] Question about scanning to MSExcel
Date: Tue, 13 Apr 1999 09:56:23 -0600


Maggie

In addition to Joy's suggestions about exporting from the OCR program, there
is an "easy" method to use with Excel that will work if all else fails.

First: Save your pages from the OCR program as text with a txt extender

Then: Run Excel, and open your text file. Excel should see the column
format (space or tab delimited) and display a series of screens to let you
manually set up the individual line "parsing" into data fields. If you have
additional "header" information on the pages, you might have to cut the
header block from the text file prior to opening it in Excel and paste it
back as an Excel "header/footer."

I use this method a lot to open and edit "strange" database reports that are
sent to me for the archives.

Lee

-----Original Message-----
From: Maggie Stewart-Zimmerman <>
To: <>
Date: Monday, April 12, 1999 3:47 PM
Subject: Re: [ARCHIVES-L] Question about scanning to MSExcel

>Lee,
> I have copies of older typewritten pages in columns, some are very easy
>to read and some are a tad blurred. The originals were on that thin
>parchment type paper. I am using Omnipage Pro that my husband brought home
>from work for me to try and I downlaoded the one that Linda suggested and
>like it too but won't have the $89 to purchase it until next month.
> I have been having pretty good success doing the OCR but can't find a
>way to get it into the spreadsheet/database format without a lot of
>manipulation.
>
> Maggie
>
>!^NavFont02F01A70007NGHHHA89E65
>
>

This thread: