Word to Excel or Access

[StephanieH]

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.....

 

[Charlie Hoffpauir]

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>

 

[StephanieH]

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.