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