Hi Naidee,
Assuming that this is a well-formatted Word document in which each label
is one cell of a table that occupies the entire document, you can set
about it like this:
1) Cut and paste the columns of the table so you end up with a tall
narrow table, one label wide.
2) Ensure that every label contains the same number of lines, and that
corresponding items are on the same line of each label. For instance, if
some addresses include a company name and others don't, those that don't
need to have a blank line where the rest have the company name.
3) Add a cell at the top of the table. In this, type the names for each
of the fields, each on a line of its own, e.g.
Name
Company
Address1
Address2
CityStateZip
Country
2) Use Edit|Replace to replace every paragraph mark (^p) with a tab
(^t).
3) Use Table|Convert Table to Text to convert the table into text, with
a paragraph mark between rows of the table.
You should now have a document in which each address is on a single
line, with tab characters between each field of the address. The first
line contains the field names.
4) Delete any blank lines from the document.
5) Save it as plain text (without layout).
6) Create an empty table in Access with the same field names as above
and the appropriate field types. Probably it's worth including an
autonumber field called ID or some such.
7) Import the data from the text file into the table.
8) If desired, add fields for (e.g.) City, State and Zip and use update
queries to split the elements out of the CityStateZip field from the
labels.
And so on.
