If I have data in Word, can I transfer to MS Access

M

Mary O

To save me having to re-type a lot of data in Word, and to have information
at my fingertips which I can sort in any way I want to, I am hoping I can
transfer all information (not in table format unfortunately) to MS Access. I
can cut and paste I suppose, but I'm looking for a quicker way. Is there?
 
J

Jeff Boyce

Mary

Unless there is some structure to your Word data, how do you propose to
transfer the data to the structure that your Access tables will need?

Could you use Word's "table" formatting to impose a meaningful structure on
the Word data?
 
M

Mike Painter

Mary said:
To save me having to re-type a lot of data in Word, and to have
information at my fingertips which I can sort in any way I want to, I
am hoping I can transfer all information (not in table format
unfortunately) to MS Access. I can cut and paste I suppose, but I'm
looking for a quicker way. Is there?
Click to expand...

What does the information look like now?
There must be something that acts as a field and *especially* a record
delimiter.

If you have

name
address
city, state ZIP
Phone

Name
etc

with the same number of lines for each record and always a line between
them, then WORKING WITH A COPY OF THE DATA you search and replace the two
linefeeds after the phone number with something that appears no place else
on the document. I usually use "|".
Then you S&R all single line feeds with another unique delimiter. ","
(which includes the quote marks) is a good one.

Now you have
name","address","city, state ZIP","Phone|Name","etc

S&R the | and replace it with "^P" if using word and you have

name","address","city, state ZIP","Phone" <CR>
"Name","etc

You place a quote mark at the start of the first line and the end of the
last line.
Look at the results but don't pay a lot of attention to details.
If it looks OK import it to Access and you'll have most of the information.
You would use Access to separate city state and zip.
 
T

Tom Wickerath

Hi Mary,

See the article available at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnimo01/html/imo1200.asp

If you'd like the downloads that were originally available for this article, then send me a
personal e-mail message with a valid return address. Please do not post your e-mail address in
this newsgroup.

Tom
________________________________________


To save me having to re-type a lot of data in Word, and to have information
at my fingertips which I can sort in any way I want to, I am hoping I can
transfer all information (not in table format unfortunately) to MS Access. I
can cut and paste I suppose, but I'm looking for a quicker way. Is there?
 
Top