Copy data between SQL and Oracle

[Andrzejek]

I have 2 places with the data: SQL Server and Oracle.
I can connect to both of them, Select the SQL Server data and insert record by record into Oracle. But this is slow, too many records.

Is there a way to do:
Insert Into MyOracleTable (Field1, Field2, Field3, ...)
Values (Select FieldA, FieldB, FieldC, ... from SQLServerTable)

 

[dhookom]

Can't you use a simple append query?

Insert Into MyOracleTable (Field1, Field2, Field3, ...)
Select FieldA, FieldB, FieldC, ... from SQLServerTable

 

[Andrzejek]

Yes, I can do this simplified version of the INSERT statement, but...
If I have:
Dim CnSQL As New ADODB.Connection
Dim CnOracle As New ADODB.Connection
...
CnOracle.Execute "Insert Into MyOracleTable ..."

How do I specify that part of my INSERT uses data from SQL Server?