I just left a project and was wondering how this would be accomplished. There is an access database that is managed by another group and we need that data in our Oracle tables. We have a query already in access that will join the various tables in the Access Database and the result of the query is in the exact layout of our Oracle Table. How would we go about creating an ODBC connection and executing an insert based on the result of the Access query?
I have done ODBC connections to view Oracle tables in Access, but never tried an insert and truncate from Access back to Oracle.