Import from word?

M

mgrader

I have a 1300+ mailing list created in Word. Is it
possible to import this into Access and have seperate
columns? ie: Name Address City State Zip
 
L

Liz

How is this set up in Word? Table?
You'll have to save it as a .txt file and then import into
Access.
Good Luck!
 
J

John Nurick

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

Mike Painter

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.
Click to expand...
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.;)
 
Top