June 25, 2008 at 3:25 am
I have a multiple Word document that that contains a tables that change over time I wish to build a database to import the data from the tables stored in a folder what do I need to do to get imports from MS Word tables and does anyone know of a script / tool to use cant be the first person to try this.
thanks
June 25, 2008 at 7:51 am
The only thing I can suggest is using VBA Office Automation to create a Word object, open the document in RAM, and read it programatically. I know that can be done (did it once in 2005), but can't say that I remember the details of how to do it.
If you can change the document to Excel, the whole thing becomes trivially easy, but there isn't a native data connection to Word. At least, I can't find one.
Word 2007 stores documents in XML format. You might be able to connect directly to that, if that's the version you're trying to read from.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply