access 2007 export to odbc macro

[midnight_dsob]

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 export from a macro?

 

[Ziggy1]

What are you trying to do...the purpose for doing this?

 

[midnight_dsob]

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.

 

[Ziggy1]

the other way you can do it is create an macro and name it AutoExec and program it to close, I have an example I'll have to dig up. then place the DB into the task sched...

 

[Ziggy1]

Ok I took a look at my work copy of Access 2007, and it threw me off at first..I'm still getting used to finding where Microsoft hid everything

There's a couple of places to check, first go to "Access Options" (click round button top left). Then "Trust Center" > "macro settings" and check off the last option "enable All macros".

Second (because that alone may not solve it), when you are in Macro design, click the button that says "Show all Actions".

it should work after that.