Loading XML Data into SQLSERVER Database.

[satya123]

Hi,
I have XML Data files. which I got from the customer. I need parse those XML files and load into the database tables.

For Eg: Xml document contains the table name and data in different tags.
<table name="xyz">
<column1 value="x">
<column2 value="y"/>
<column3 value="z"/>
</table>

I need to read those table name and column values and write into corresponding database table with their column values. I have to do this in SQL server database using VB.NET



Please help me how can I do this.

Thanks...
Satya

 

[lingsn]

Hope this help

http://www.dbazine.com/sql/sql-articles/cook2