#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Thanks eNGiNe. I am not sure if the styles are available in Word 2003. I know this feature is available for Word 2007.
|
#4
|
|||
|
|||
Some familiar gurus have discussed this question in microsoft-word-answers.com
The bottom line seems to be "Yes, but differently": Quote:
|
#5
|
||||
|
||||
Quote:
Quote:
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] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to transfer multiple excel cells into specific place in word document by formulas | anton | Excel | 1 | 12-20-2011 03:56 AM |
How to create an Excel add in that will automatically build tables from data | selvamariappan | Excel Programming | 1 | 12-12-2011 03:11 AM |
Is it possilble to transfer data from Excel to Publisher? | markhuges | Publisher | 8 | 10-23-2011 05:55 AM |
How to transfer Word 2003 Tables to Excel? | steeleye | Word Tables | 1 | 07-10-2009 04:18 PM |
How to transfer multiple cells from excel to word by formulas | justziggy | Word | 5 | 05-23-2009 02:33 AM |