I, too, have had success with the "Microsoft ODBC Driver for Oracle" in the past, but now (since I have a different machine), whenever I push the Next button, nothing happens. In fact, it does not even appear that a connection is attempted.
As far as Access connectivity goes, I'm really confused as to why this driver does not appear in my Data Sources list even though I can setup an ODBC setting through Control Panel. Even when I do that, though, and I use "Other ODBC" as you suggest, the Next button does not move to the next window. I'm obviously missing something or did not install something correctly (BTW, I have MDAC 2.8 installed).
Right now, I'm trying to get my Access data into SQL Server using Access's Upsizer tool. But that gets me to SQL 7, not 2K (I received an Overflow error when I tried to go directly to 2K). What a roundabout way to do things!