By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,404 Members | 2,300 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,404 IT Pros & Developers. It's quick & easy.

scheduling an export

P: n/a
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

Nov 10 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 10 '06 #2

P: n/a

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

Nov 11 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.