How to export table in spreadsheet format automatically at given time or date?

[ProwlingEyes]

I have a simple and small database having only one table. I want the data table to be exported in a spreadsheet format automatically at the end of the month. Is there any code or function to do that?

 

[MarkK]

I would do this using a Windows scheduled task. You can get Windows to open a database that runs code automatically when it opens. You can also run a script file.