Import a Word 2003 address list into Access & get into tbl fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to import a simple line for line Word address into Access
and place the CR Line feeds into the preset table FIELDS? Thanks!
 
Hi Gary,

In my experience there's no such thing as a "simple line for line Word
address". Are you talking about a Word document that contains nothing
except a single address

Mr Joseph J. Blow
123 Acacia Avenue
Sometown, NY 222222

or a Word document full of addresses formatted for mailing labels, or
pulling the recipient addresses out of a bundle of letters, or what?

How many addresses are there?

Please also explain more clearly what you mean by "place the CR line
feeds into the preset table fields"? Do you want to split the address
and put one line into each field, or put multiple lines of address into
a single field?

Also, can you guarantee that every address will have exactly the same
number of lines with the same items on each line, or is it possible for
them to vary (e.g. with a company name and/or building name, or
international addresses)? What are the fields you want to separate the
addresses into?
 
Back
Top