Extracting Data

[Alex Hammerstein]

Hi really hope someone can help

I have been sent a Word documents 250 pages long and which contains
addresses. I need to get these into either Excel or Access.

Each address is 4 lines and there is 2 or 3 line feeds between each address.

Is there anyway I can extra this data into and Excel worksheet or Access
table?

Very many thanks

Alex

 

[Barry Schwarz]

Hi really hope someone can help

I have been sent a Word documents 250 pages long and which contains
addresses. I need to get these into either Excel or Access.

Each address is 4 lines and there is 2 or 3 line feeds between each address.

Is there anyway I can extra this data into and Excel worksheet or Access
table?

Does select all followed by copy and paste not work?

 

[Alex Hammerstein]

Sorry probably didn't make myself clear.

What I want to do is to bring each address onto a single row in Excel or
Record in Access, so that we can manipulate the data. Cut and Paste put an
address on 4 rows of column A

Alex

 

[Jay Freedman]

Take a look at
http://www.gmayor.com/convert_labels_into_mail_merge.htm.

Once the addresses are in a Word table at the end of that process, you
can copy the table and paste it into an Excel worksheet. If you want
to use Access, see
http://www.word.mvps.org/FAQs/TblsFldsFms/WordToAccess.htm.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

 

[macropod]

Hi Alex,

In Word, assuming your 'line feeds between each address' are really paragraph breaks, do a wild-card Find/Replace, with:
Find = (^13{2})^13{1,}
Replace = \1
This ensures there's just a single paragraph between each address. Then select the whole document can convert it to a 5-column table
(Table|Convert|Text to table).

You should now be able to select the first four columns of your table and paste it into Excel.

 

[Barry Schwarz]

After you have the address in 4 rows, it should be pretty easy to
record an Excel macro to move the data in the last three rows to
individual cells on the first row