Moving data from SQL Server to Oracle via ODBC

I am moving data from SQL Server 7 to Oracle. I started with the easiest way I know. I opened Access and link tables via ODBC to both databases. I then wrote a function to to go through each table looking for matching table names plus a predicate ("dbo_" for SQL Server and "BRIAN_" for Oracle) and simply doing an INSERT INTO table SELECT * FROM table. However, with at least one table that has over 40,000 records, this takes a short while. We are planning on importing it more than once as we test different things. Is there a faster method?

Brian Received on Tue May 16 2000 - 00:00:00 CDT