John Nurick said:
Hi,
It's possible: but depending on just how the data was entered in Word it
can be easy, or it can require advanced programming skills plus
extensive manual editing. Please post detailed information on how the
names and addresses are laid out in the Word document.
Usually the problem is in-between someplace and can be solved by working
with a copy of the data.
E.G.
<cr> is the paragraph mark.
name <cr>
address<cr>
city, ST ZIP <cr>
<cr>
Name<cr> ....
In Word you would search and replace all <cr><cr> with a delimiter, I
usually use "|" the pipe symbol.
Then you replace all <cr> with "," (include the quote signs)
Then replace the "|" with <cr>.
Add the quote to the first line and at the end of the last line, save as a
text file and import.
It is easier to parse the city state ZIP in Access if you have to.
(If you've done this as often as I have you know why you work with a copy.
