You could just create an ODBC connection to the Oracle database and go into access and do a "Save as/Export" to the ODBC Oracle database. The thing to be careful with is to make sure the exported table name is in uppercase or you may have problems accessing it.




Reply With Quote