I ran some tests years ago (have since lost the results). Getting lots of data into SQL Server, bulk import was fastest. Other than that, there was really no difference between ODBC and OLEDB.
>Depending on how you get your data -- a bulk import will be the fastest, by far. If you aren't doing a lot of these it may not make a difference.
>
>There are also ways to turn off various sql features to make imports faster. Google on 'sql server imports make faster' and you will see a ton of information. This is a common issue.
>
>Hank
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer