Import from word?

  • Thread starter Thread starter mgrader
  • Start date Start date
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
 
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!
 
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.
 
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.;)
 
Back
Top