How I can load data from Access to oracle table?
dumop the access data in to flat files and use sql*loader or in 9i external tables to load the data. I don' think there is a transparent gateway that will allow Oracle to connect to Access but I could be mistaken.
I'm stmontgo and I approve of this message
An easier way is to connect from Access to Oracle using Oracle ODBC drivers, and push the data from Access to Oracle tables
"The Oracle Sponge"
Senior Manager, Business Intelligence Development
XM Satellite Radio