Data transfer from Word tables to Excel
I received Word 2003 data files and I am trying to pull the data from it and import in Excel in tabular format. The challenge is the way Word document is formatted with field names and data appearing side by side and with description field has data appearing below the field name. I want to be able to put this into datasheet format to maintain a small database.
sample layout:
ID: 12344, Sponsor: Mr abc
Business line: business1 Head Sponsor: Mr zee
country: lalaland
description:
this record is different
ID: 12345, Sponsor: Mr efc
Business line: business3 Head Sponsor: Mr Kay
country: seasame
description:
Another weird format
Can anyone please suggest as to what would be best way to extract data accurately.
Thanks
shoro
|