I need a programmatic approach, as I have to run daily jobs of loading data from mdb file to oracle database. Once I convert to mdb to csv.I can use sql loader to load into oracle. Please suggest if I have any other options.
Another approach would be to use the Oracle Database Gateway for Windows on a Windows OS based machine and now using the MS Access ODBC driver for Windows to directly access the MDB file from the Oracle database.
There are notes available in My Oracle Support portal how to configure DG4ODBC: