Post reply

Help on how to shred, Xquery a docx in SQL 2005 SP2

  • July 15, 2009 at 1:58 pm

    #136177

    I've been sent a Word.document (MS 2007) and need to break down then the elements and load them into a table. I think this is little difference than previous word documents.

    The package name is ="/word/document.xml", pkg:contentType="application/vnd.openxmlformats-officedocument.wordprocessingml.document.main.xml".

    The xmlns:ve="http://schema.openxmlformats.org/markup-compatibility/2006", xmlns:o="urn:schemas-microsoft-com:office:office"

    I have had much luck with XQuery.

    Any and all suggestions would be appreciated? The document is a little bit over 164,416 lines

  • July 15, 2009 at 2:19 pm

    #1025352

    Would you mind to provide some sample data as an attachment so we can test if a solution someone may think of actually works and is giving the expected result?

    20 to 30 lines with corresponding xml tags should do it.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • July 16, 2009 at 12:42 pm

    #1025855

    Lutz,

    Thank you for your reply.

    This is an Openoffice xml document. A link to more information about openoffice xml is here:http://blogs.msdn.com/ericwhite/default.aspx

    I'm looking for the values in and I've included a sample of what the data looks like below. The file below is not a complete file.

    Thanks you all!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply