I'm trying to schedule an automatic export from access to an oracle database. In previous versions of access you could export a macro and then schedule it with windows scheduler. I assume you can do the same in 2007 somehow.
Access 2007 has this lovely export to ODBC database which you can save the steps you took as a 'saved export'. It exports your query to a table in whichever ODBC db you specify. However the only option for scheduling is to have it create an outlook task. Does anyone know a way to run this saved...