Automatic export to excel from access

Question

I have to create an excel template to which i have to export data from my access2010 db. how do i do both and in an automatic way

as the report is required daily and momthly.

2. from my form, i have to print a receipt with only the current record(preferably on textfile) how do i do it and how do i keep the

record in final format for future refetence etc?

Answer 1

Re your first question:

Exporting data to a prepared Exel template (as opposed to a new blank workbook which can be done with DoCmd.TransferSpreadsheet) can be done with automation. Have you seen this KB article? http://support.microsoft.com/kb/306022

In an automated way: this would require setting up a task in the Windows Scheduler:

http://windows.microsoft.com/en-US/windows7/Schedule-a-task

This would invoke msaccess with a special command line switch /cmd or /x:

http://support.microsoft.com/kb/209207

Then your code or macro could export the data to Excel, and close Access.

Re your second question:

Better to post a new question, with a proper subject line, so people can readily find it.