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

G

Gary

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!
 
J

John Nurick

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top