August 21, 2008 at 3:35 pm
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
August 22, 2008 at 2:46 am
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]
August 22, 2008 at 8:17 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy