Automate the "Export to Excel" function?

[Richie2837]

Hi guys,

I regularly export the main table in our database to an excel spreadsheet, to provide an additional level of data back-up. (Using File/Export)

I was wondering if there is a way of automating this process, either through a command button on a form, or by linking it with shutting the database down.

Any ideas?

 

[boblarson]

Yes, you can use a button with code that uses

DoCmd.TransferSpreadsheet (type that into your click event of your button and then press F1 for the helpfile to bring up help on that command and the rest of the parameters.