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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 ADO , XML, SQL Server 2000
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

majnoon
Starting Member

United Kingdom
26 Posts

Posted - 04/09/2003 :  10:14:17  Show Profile  Reply with Quote
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

Australia
1479 Posts

Posted - 04/09/2003 :  20:05:50  Show Profile  Reply with Quote
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

majnoon
Starting Member

United Kingdom
26 Posts

Posted - 04/10/2003 :  04:22:24  Show Profile  Reply with Quote
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

robvolk
Most Valuable Yak

USA
15732 Posts

Posted - 04/10/2003 :  07:41:59  Show Profile  Visit robvolk's Homepage  Reply with Quote
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.

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000