June 14, 2005 at 8:37 am
I have to import several hundred word documents into sql server. The documents all have the same layout (several tables) and I want to keep the data in each table in a separate field. Can anyone help?
June 14, 2005 at 8:46 am
Why would you want to use a denormalized design like this?
Why not keep the whole thing on the server's hd?
June 14, 2005 at 9:24 am
I think you'll have to code something in word vba that'll read the text and insert the data in the db. It's gonna be much simpler than trying to insert the whole thing and split it back up again.
June 14, 2005 at 10:55 am
Although I am very anti xml, I thank that this may help you out in this regards. I found this link a while back and it's very good if you only want to store parent with children data rather than multiple duplicate children.
Basically, its sets up a word template which can then be typed in by a user. You then get the document back, saved in xml and it gives you a nice xml document you can import easily into sql server.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_wd2003_ta/html/odc_wdov.asp
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply