StephanieH
Wed May 31 11:11:02 CDT 2006
Thanks Charlie. That's pretty much what I ended up doing. I created a macro
to copy/paste from Word to Excel, then to import to an Access Database. At
any rate, the information will be much easier to find now.
"Charlie Hoffpauir" wrote:
> On Fri, 26 May 2006 11:41:02 -0700, StephanieH
> <StephanieH@discussions.microsoft.com> wrote:
>
> >I've inherited numerous Word documents that should have been prepared in
> >Access or Excel originally. They are basically logs with a name and account
> >number. There is Header at the top of each page which contains information I
> >don't really need. Included in the Header are the Column headings "Name" and
> >"Account Number". In the body of the text, the person typed the name then I
> >believe tabbed over to type the account number.
> >
> >Is it possible to convert these to Access or Excel? Right now, I can copy
> >and paste the information but there are several documents. I'll be here all
> >night.....
> >
>
> Copy/Paste should go quite fast. Unless you have a huge number of
> pages, that's probably the best way to go. If you do have a large
> number of pages, and the formatting of all is the same, then you can
> write a fairly simple macro in Word to strip out the column headings
> and other information you don't wnat to transfer. That should speed
> things up a lot, sincce you could them transfer large blocks of data
> at once.
> Charlie Hoffpauir
>
http://freepages.genealogy.rootsweb.com/~charlieh/
> Message board:
>
http://boards.ancestry.com/mbexec?htx=board&r=rw&p=surnames.hoffpauir
> Mail list:
>
http://lists.rootsweb.com/index/surname/h/hoffpauir.html
> DNA project:
> <
http://www.familytreedna.com/(153dme45ewxtrs45rzxk5z2x)/public/Hoffpauir/index.aspx>
>