How to import an xml file into a sql 2000 database

  • Juanita

    SSCertifiable

    Points: 5300

    Hello

    I have to import 4 xml files into an existing sql 2000 database. Can someone help me on how to do this? Do I need to install any additional components to my existing sql 2000 installation?

    any help would be greatly appreciated!

    Juanita

  • MarkusB

    SSC-Dedicated

    Points: 37370

    How do you want to store the data in SQL server? Do you just need to place the whole xml document into a text or varchar column or do you want to shred the document into relational data?

    In the first case a bulk insert should work, in the second case have a look at the OPENXML function.

    [font="Verdana"]Markus Bohse[/font]

  • Juanita

    SSCertifiable

    Points: 5300

    Hello,

    I am importing this into existing sql tables into individual fields. I have been reading that I need to install something called sqlxml? Does this sound familiar?

    Juanita

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

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