471,321 Members | 2,076 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,321 software developers and data experts.

Inserting a Dataset into a database

RSH

I have a situation where I am transferring data from an Access database to a
SQL Server database.

Basically I am populating a dataset from the Access database and now I want
to insert that data into SQL Server. The schemas are the same so I was
wondering if there was a way to just perform a mass insert without having to
loop.

Thanks!
Ron
Dec 22 '05 #1
1 1189
Hello RSH,

Isn't that your answer http://groups.google.com/group/micro...a22e3290283a81

R> I have a situation where I am transferring data from an Access
R> database to a SQL Server database.
R> Basically I am populating a dataset from the Access database and now
R> I want to insert that data into SQL Server. The schemas are the same
R> so I was wondering if there was a way to just perform a mass insert
R> without having to loop.

---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/members/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche
Dec 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Pushpendra Vats | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.