DATA IMPORT from MS.ACCESS TO ORACLE DATABASE
I have an MS ACCESS MDB file , I to import all the Tables and Data into ORACLE DATABASE through FORMS.Because this file is on Client side, and maintain on daily basis ,so it is very hard to import manually daily through traditional ODBC method,for that our one team member busy all day with that issue.
Is it possible in our forms to import data from MS.ACCESS to ORACLE. I tried HOST command but it doesn't work.
Data structure and Table Name are same both is MS Access and Oracle.
We are Oracle 8i and Developer 6i