Post reply

XML to SQL Server Database Table

  • August 9, 2007 at 3:50 pm

    #373148

    I have an "xml" file and a table waiting for the data.

    The question is simple - how do I export the data in the "xml" file to my "waiting" table.

    Thanks guys (and girls).

  • August 10, 2007 at 2:26 am

    #725920

    you can pass the xml to a stored procedure with ntext datatype and then use openxml to load the data into your table. look in BOL for usage of OPENXML

    or you can use bulk loading

    http://msdn2.microsoft.com/en-us/library/Aa225754(SQL.80).aspx

    or you can use openrowset, again ref to BOL

     

    if you get any problems using any of the above just post your solution and we will help you sort it out

    Everything you can imagine is real.

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

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