Hi, How I can load data from Access to oracle table? Thanks
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. steve
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
David Aldridge, "The Oracle Sponge" Senior Manager, Business Intelligence Development XM Satellite Radio Washington, DC Oracle ACE
Forum Rules