I want to transfer a 10 million record database from Oracle into SQL Server
using MS Access 97.

What is the fastest method in which to do this?

Your thoughts are appreciated!

John

Wow!
I'd like to hear how you finally end up doing this.
If you have ODBC drivers for both and can attach both tables to one mdb,
then maybe you can just write a query to select from one and append to the
other.

Alternatively, SQL server has a bulk update feature that can be used
directly on certain types of files.  Maybe you could dump the data into that
type of file first from Oracle and then upload that way.
Good luck.

You could export the Oracle date to ASCII delimited files then use SQL
Server bcp (bulk copy program) to import the files to SQL Server.  There is
more info on bcp in SQL Server books online.

--
Bob Pfeiff
MCSD, SQL Server MVP

I'ld go for the ascii export. So dump the records into text files (using
PL/SQL or SQL*Plus), then use bcp to read them into SQL server.
Whatever you do, don't try inserting them into the new tables using ODBC
(unless of course you've got, say, two weeks or so).

G'luck
Gabri