Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mass Append from DataSet

Status
Not open for further replies.
livezone

livezone

MIS
Jan 17, 2003
81
CA
Hi,

I have filled my dataset from an XML file. I want to add all the records from dataset to a SQL table. Is there a way to do a mass append all the records from dataset to sql table instead of issuing Insert command one by one.

Thanks
Shafiq
 
Sort by date Sort by votes
If you go to MSDN.Microsoft.com, search for a SQL XML tool. I believe it is an add on to sql server which will allow you to do this, although I have never used it.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
GET date from classname
Replies
2
Views
163
2009luca
2009luca
2009luca
  • Locked
  • Question
GET splitted value from node and sub node in treeview
Replies
1
Views
167
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
FORMAT output of Debug.Print .responseText (from api rest)
Replies
4
Views
177
2009luca
2009luca
sal21
  • Locked
  • Question
DOWNLOAD csv file from web
Replies
5
Views
163
strongm
strongm
sal21
  • Locked
  • Question
how to read the coordinates in from this file
Replies
3
Views
211
Ken01
Ken01

Part and Inventory Search

Sponsor

Back
Top