There's an XML extension to SQL Server 2000 for working with XML directly.
Here's an example:
http://www .devx.com/ vb2themax/Tip/18777
(what for spaces).
Have done most of this in the past (and could dig up examples with inserts,update,deletes, parent-child inserts, etc.)
rob
karunasingh7 < karunasingh7%40yahoo.co.in">karunasingh7
yahoo.co.in> wrote: I am using Net2.0 with Sql Server 2000
I want to insert data in sql server table from an xml file ...I came to
knw abt manually reading xml file and making queries to insert data.
is there any other way to do this ?
Thanks in advance..
---------------------------------
Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool.
[Non-text portions of this message have been removed]
.