periodical query export into .txt file

[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

 

[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

 

[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




.