asked on

Word 2007 table info to Excel worksheet

I have several hundred Word 2007 files that are comprised of 5 tables with the same information. (Actually the fields are the same but the information may be filled in for that field on one document and blank for that same field on another.) I am trying to figure out a way to import the data from these fields into an Excel 2007 worksheet. I have tried converting the tables to text and saving as a delimited file which I imported into Excel and I have tried doing a cut and paste. Either I get nothing at all or all the fields end up in one column and multiple rows. I need each Word document to be a single record with one row and multiple columns. I am working with files from Office 2007 and 2010.

wchh

Just Copy from word (table) and paste to excel...

jkidda

ASKER

I tried that but it doesn't break up the parts of the table in the proper columns. I have 1800 of these documents so I was hoping not to have to do 5 copy and paste from the 1800 documents. The tables contain the field name and the info that goes in the field. I need to extract the information without the field names. If I can extract them all but in separate columns, I can delete the field names out to clean it up.

wchh

Any sample of word table?

MWGainesJR

Can you post a sample doc file

jkidda

ASKER

Here is a sample. I have highlighted the fields that would be column headers. The file is saved as a Word 97 document. I can use them as is or convert them to Word 2007 or 2010. They will ultimately end up as an Excel 2007 file.
Admiral-BaybrookGateway.doc

ASKER CERTIFIED SOLUTION

Helen Feddema

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Helen Feddema

Another approach would be to create a Word macro, run from a toolbar button in the Word Template (hopefully these docs are all made from a template), which would export data from that document to a new Excel workbook.

jkidda

ASKER

The Word documents are all identical in form but the were not created using a template. I like the idea of your suggestion about using the automation code to fill in data under the column headings in the workbook. I just have to play with some of the code to see if I can pull that off. I'm only vaguely familar with using automation code. I will download the code and play with it. I guess I could also load it into Access and then dump it to Excel from there. It's an extra step, but it beats the alternative.

Helen Feddema

If you are familiar with VBA, you should be able to cobble together something that will work, using the code from the code sample and article.

jkidda

ASKER

Helen,

Thank you for sharing the code examples with me. After looking them over, I realized it has been way to long since I coded in VB. I'm not even sure where to begin to build the code needed to move my Word table data into Excel. I appreciate your help and suggestion but will have to continue to look for another way to import the data.

Tracy

This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.