scheduling an export

[Zviozdi]

Hello,
Do you know how to schedule a weekly export of one table to a text file
from access 2000 on windows xp?
Thanks,
Eyal

[NthDegree]

Create a module that contains a function (not a sub) to export the table and
then exit the application (docmd.quit), then create a macro named autoexec
that uses the runcode function to run the function you created to export the
table. Use your Windows job scheduler to run the access program using
command line parameters like:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
C:\SomeFolder\SomeApplication.mdb

and schedule it to run once a week or whenever.
<Zv*****@gmail.comwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...

Hello,
Do you know how to schedule a weekly export of one table to a text file
from access 2000 on windows xp?
Thanks,
Eyal

[pietlinden]

NthDegree wrote:

Create a module that contains a function (not a sub) to export the table and
then exit the application (docmd.quit), then create a macro named autoexec
that uses the runcode function to run the function you created to export the
table. Use your Windows job scheduler to run the access program using
command line parameters like:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
C:\SomeFolder\SomeApplication.mdb

and schedule it to run once a week or whenever.

Or you could use the Scheduler here:
http://www.mvps.org/access/modules/mdl0042.htm