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 |
|
majnoon
Starting Member
26 Posts |
 Posted - 2003-04-09 : 10:14:17
|
| Hi All:I have a small VB app that creates an ADO resultset from an XML file, can I import that resultset into a table in SQL server 2000. If so how??Thanks in advance of your help!!Wishing you a peaceful journey |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-04-09 : 20:05:50
|
| Hi manjoonas far as I can see you'll basically have to do it "automanually" by looping through the ADO set and inserting the records into SQL Server.There may be another option if you have the latest ADO, but I don't, so can't help you there. Is there a problem with just looping through?--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
majnoon
Starting Member
26 Posts |
Posted - 2003-04-10 : 04:22:24
|
| The only real problem with looping is that the resultset is quite large (approx 250,000 records)Wishing you a peaceful journey |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-04-10 : 07:41:59
|
| SQL Server 2000 has means to bulk import XML, go to http://www.microsoft.com/sql and look at the XML links. You can also use XSL to transform the XML into a flat file, which you can import using DTS, bcp, or BULK INSERT. You definitely don't need to loop anything. |
|
|
|
|
|
|
ADO , XML, SQL Server 2000