periodical query export into .txt file

N

Nejc Kovacic

I've made some queries in Access. I want to run those
queries on daily basis and save (export) results in .txt file.
Is it possible to make all that without any user
intervention - fully autmatically?
Thanks!!

BR,

Nejc
 
S

Steve Schapel

Nejc,

To do this with a macro, all you need is a TransferText macro, one for
each of your quesies, referencing the query in the Table Name argument
of the macro action. It is advisable to run through the export
manually, via the File|Export menu, and at the last screen of the export
wizard, click the Advanced button and save the setup as a Specification,
and then refer to this Specification also in the macro arguments.

Then, you need to use Windows Task Manager, or some third-party
scheduling software, to run the macro at a certain time. The Command
Line of the scheduler will probably follow this syntax...
"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\YourDB.mdb" /x NameOfMacro
 
N

Nejc Kovacic

Thanks!
BR,

Nejc
-----Original Message-----
Nejc,

To do this with a macro, all you need is a TransferText macro, one for
each of your quesies, referencing the query in the Table Name argument
of the macro action. It is advisable to run through the export
manually, via the File|Export menu, and at the last screen of the export
wizard, click the Advanced button and save the setup as a Specification,
and then refer to this Specification also in the macro arguments.

Then, you need to use Windows Task Manager, or some third-party
scheduling software, to run the macro at a certain time. The Command
Line of the scheduler will probably follow this syntax...
"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\YourDB.mdb" /x NameOfMacro




.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top