Converting Word Documents to Excel Spreadsheets

[DataChick]

I have 100+ word documents that all consist of the same 6 tables in the same order - but some of them have one line of data and some have 10 lines of data in them (no two are ever the same).

I need to get this data into an excel spreadsheet to gather some other information and then load into an Access database.

I've coded extensively in both Excel and Access but never in Word.

Can this even be done and, if so, can you give me an idea how to start? I'm completely clueless about this (referencing cells, etc.).

Thanks in advance.

"The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents."
-Nathaniel Borenstein

 

[Bong]

In Word, if you "select" the table, then "copy"; then in Excel, "paste", you get the proper allocation to cells. I suggest you turn on the Macro recorder in Word, perform the steps above, and see what you get.

_________________
Bob Rashkin

 

[DataChick]

Thank you!!! That was very helpful (since I didn't realize there was a Macro Recorder in Word)...now I have an idea of what I can do!!!!

"The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents."
-Nathaniel Borenstein