|
Home > Archive > MS Access data conversion > November 2005 > mailing labels to access table
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
mailing labels to access table
|
|
| WebBuilder451 2005-11-14, 9:24 am |
| 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
--
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes
| |
| Jeff Boyce 2005-11-14, 8:25 pm |
| 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>
"WebBuilder451" < WebBuilder451@discus
sions.microsoft.com> wrote in message
news:96C9FF59-B404-486C-8194- 27C46664CF37@microso
ft.com...
> 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
>
> --
> thanks (as always)
> some day i''m gona pay this forum back for all the help i''m getting
> kes
|
|
|
|
|