periodical query export into .txt file

  • Thread starter Thread starter Nejc Kovacic
  • Start date Start date
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
 
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
 
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




.
Click to expand...
 
Back
Top