Data transfer from Word tables to Excel

macropod · #5 10-01-2013, 05:08 AM

Quote:

Originally Posted by shoro

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

Word has always used Styles.

Quote:

Originally Posted by shoro

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.

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

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