mailing labels to access table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WebBuilder451 - 14 Nov 2005 14:50 GMT

I've been given a word document with about 400 names and addresses. These are
in a avery mailing label format. Can anyone suggest a good method for
importing them into an Access table.

I realize there will be some percentage of error, because some have two
addr lines, apt #, ..., but i'm sure there has to be a good way to at least
get started.
thanks

Signature

thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes

Reply to this Message

Jeff Boyce - 14 Nov 2005 22:59 GMT

If you "regularize" your data in Word, your import into Access will go much
more smoothly.

So if you add in <placeholders> for all the names/addresses (e.g., empty PO
Box line, empty Address2 line), all the imported records should fit in the
same table.

Regards

Jeff Boyce
<Office/Access MVP>

> I've been given a word document with about 400 names and addresses. These
> are
[quoted text clipped - 6 lines]
> get started.
> thanks

Reply to this Message