Not easily.
I assume you mean that the list is in a Word table, with each address in
several paragraphs in one cell of the table.
1) First, rearrange the table so it is just one column wide but much
taller.
2) Then, make sure that each line in each cell contains exactly the same
field(s). If these are standard US residential addresses this may
already be the case (every record consists of
Name
Address
City, STATE Zip
Where things get complicated is when the records aren't laid out
consistently: for instance, if some are like this above and others are
Name
Company
Address
City, STATE Zip
In that case, you'd have to insert an empty paragraph in each address
that doesn't have a Company name. International addresses add further
complication.
3) If there aren't too many records and you want to be able to search or
sort the data by city, state or zip code, change
City, STATE Zip
to
City
State
Zip
so it will import automatically into separate fields.
4) Same if you need the Name divided into separate fields (e.g.
Title
FirstName
MiddleName
LastName
Suffix
3) Remove any blank lines that don't reflect missing fields.
4) Use Word's Replace to replace all paragraph marks in the table with
tab characters (replace ^p with ^t). This converts each address into a
tab-separated record.
5) Delete everything in the document except the table.
6) Convert the table to text.
7) Save the result as a text file with no formatting.
8) Import it into Access.
9) If necessary, use a combination of update queries and manual editing
to sort out City, State, Zip and the name fields.
