Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
khusiie
Yak Posting Veteran
78 Posts |
Posted - 2008-04-15 : 11:43:00
|
Can anyone tell me how to convert XML files into SQL server 2005?i have so many XML files and want to convert it into SQL server.thanks for ur help. |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-15 : 11:50:12
|
You mean store it in sql 2005? You can use a field with built in datatype xml to store the values in sql table. But make sure they are well formed else it will error. The bulk import of XML files to table can be done by means of BULK INSERT statement.Refer this article for more methods:-http://msdn2.microsoft.com/en-us/library/ms191184.aspx |
|
|
|
|
|