mailing labels to access table

W

WebBuilder451

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
 
J

Jeff Boyce

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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top