Most efficient way to transfer OdbcDataReader to sql server

I havent seen anyway to transfer the data over to sql server in a graceful
way. I have to generate sql statements dynamically or loop through each
record and call a stored procedure. Is there a more efficient/bulk way of
moving the data?

PS: Assume I cannot use DTS and the ODBC connection must be established
dynamically, meaning I cant create a DSN.

--
Craig Lucas
President
ByDesign Software, Inc
phone: (954) 605 - 1674


.