You can specify the name of a macro for msaccess to run on startup w/the /x
parameter of the msaccess executable. That macro can do a RunCode action to
run a VBA procedure that you specify (which is where you can do your data
loading) followed by an Exit action to shut down msaccess. IIRC, you
Gurus,
We would like to load data from MS Access 97 database
to Oracle 8.1.7 database with MS scheduler? Is it
feasible? It could be done in MS SQL server with the
helps of DTS package.
Please share your experience in this regard and let me
know what could be the best method to automate loading
Hi Bob,
I don't know if its possible to do it by those means, but it is
definitely possible, using heterogeneous services to have Oracle pull
the data from Access over a database link. You could schedule that
through the Oracle scheduler, or have MS scheduler execute a sql script.
HTH.
Beth
