Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 ADO , XML, SQL Server 2000

Author  Topic 

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

SQLTeam Poet Laureate

1479 Posts

Posted - 2003-04-09 : 20:05:50
Hi manjoon

as 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"
Go to Top of Page

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
Go to Top of Page

Most Valuable Yak

15732 Posts

Posted - 2003-04-10 : 07:41:59
SQL Server 2000 has means to bulk import XML, go to 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.

Go to Top of Page

- Advertisement -