Import XML and its attribute into SQL server 2000

khautinh · #1 (**permalink**) April 13th, 2005, 09:57 AM

Hi all,

I have this xml file
<root>
  <TermAndCondition SectionTest="section1">
    <TermTitle Section="section1" lvl="1">1. Test level 1.
      <SubTitle Section="section1" TermTitle="1. " lvl="2">
        a. Test Level a.
      </SubTitle>
      <SubTitle Section="section1" TermTitle="1. " lvl="2">
        b. Test Level b.
      </SubTitle>
    </TermTitle>
  </TermAndCondition>
</root>
What I would like to do is input this small xml data and its attribute into SQL server 2000 with C#. And I have a table in SQL server 2000 to store all these data. Can anyone have any sample codes please help? I am appreciated all helps.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to import XML into SQL Server	dbellavi	XML	1	February 26th, 2008 06:02 AM
SQL Server 2000 DTS Excel Import Error	Tglover	SQL Server DTS	0	June 22nd, 2007 12:27 PM
Import Fixed length - SQL SERVER 2000	carumuga	SQL Server 2000	4	December 23rd, 2006 10:18 AM
Import Data In MS SQL SERVER 2000	The Beginner	Classic ASP Basics	1	August 14th, 2006 04:59 PM
Import delimited flat file into SQL Server 2000	DevCsharp	C#	1	April 27th, 2005 11:52 PM