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

 

[Michael Nemtsev]

Hello RSH,

Isn't that your answer http://groups.google.com/group/micr...tnet+insert+dataset+database#afa22e3290283a81

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