Import from Word??

  • Thread starter Thread starter Matt Barkan
  • Start date Start date
M

Matt Barkan

Hey all. I have a list of addresses in MS Word that I need to import into an
Access data base.

I'd like one field for the for the first line of the address, another for
the second, etc...but I'm finding this incredibly difficult to accomplish.

Can anyone help?

I'm doing this because I need to do a mail merge...can this be done with a
list of addresses right from a Word or a text document?

Any help would be greatly appreciated. Thanks!

Matt
 
Are those addresses in a Word mail merge database or just in a Word
document?

If they are not in the database, you will need to get them into a form
that Access can read. Best bet would be a semicolon delineated form

Change:

John Smith
123 Main Street
Anytown, ST 12345

To:

John Smith;123 Main Street;Anytown, ST 12345

If you have some four line address, accommodation needs to be made for
that.

Personally I would suggest a little more complex system to have table
with:

First Name:
Middle Name:
Last Name:
Address Line 1:
Address Line 2:
City:
State:
Zip:

This will allow a lot more flexibility in the future. It will mean
adding a few more semicolons and a little more planning, but if you are
going to continue using this information, you will thank me for suggesting
this in the future.

Note adjustments may be made for additional address lines c/o etc.
 
Back
Top