Automatic Exports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can Access export to Excel automatically, i.e. once a week, export a table
and its contents into a predefined excel spreadsheet. If so how

Thanks
 
Hi Matt,

It's possible, but how best to do it depends one how automatic you want
it to be, how reliable you need it to be, whether the database is split,
and some other factors.

One approach is to create a macro in the database that exports the data
(or that calls a VBA procedure that exports the data), and then set up a
Windows scheduled task to run once a week and launch the database using
the /x command line switch to call the macro (see the help topic
"Startup command-line options").

But Access and other Office applications aren't designed for unattended
operation. For example, if something goes wrong it may put up a message
and wait for the user to intervene - which is a problem if there's no
one looking at the screen. So if you need it to be as reliable as
possible and notify someone if something goes wrong, things can get more
complicated (see http://support.microsoft.com/Default.aspx?id=257757 for
details).
 
Back
Top