Here is my current dilemma:

I have a table located in an Oracle database, from which I would like to
copy its ID field records into a temporary table within a SQL Server database,
so I can run a INSERT INTO...SELECT query. My dilemma is what is the best
and fastest way to mass insert that data into the temp table from one ODBC
connection through another. I would like to rule out the record by record
single line insertion there a better way, a way to perform a
mass insertion from one ODBC connection recordset into the other ODBC connection?
Please help, do not want to go line by line...