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

speculatively … I'd start by using styles to apply the labels (such as country and description). Assuming this approach – including a style separator where your Word doc shows two fields ID and sponsor on the same line – works, I believe you may then be able to save as text to discard the style-driven labels.
But we can be confident that someone else will come up with a clearer, tested answer, including advice on usign numbering for labels and on rotating rows of data (one record/one row is usual for a spreadsheet). I'll follow the thread and learn something myself.

Thanks eNGiNe. I am not sure if the styles are available in Word 2003. I know this feature is available for Word 2007.

Some familiar gurus have discussed this question in microsoft-word-answers.com

The bottom line seems to be "Yes, but differently":
HTH

Word has always used Styles.

Are your data in actual tables, or just laid out in a tabular format? If in tables, are they all in the same table or in multiple separate tables? Do all records contains the same set of fields (regardless of whether they have data)?

Can you attach a document to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab.

For examples of what can be done (provided the data have a meaningful structure), see:
http://www.vbaexpress.com/forum/show...ent-into-excel
http://www.vbaexpress.com/forum/show...el-spreadsheet
http://www.vbaexpress.com/forum/show...ata-into-Excel
http://www.techsupportforum.com/foru...el-654086.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]