I want to use an SQL Server database to connect to our commercial accounting software overnight and take a snapshot of the data.

This will be used to run stored procs and save "extracts" as Excel files for people to use for various reporting the next day.

Firstly, is this possible!!!

Secondly, would anyone be able to give me any tips/advice about how to get started with this exercise or where I can find online resources to help with this.

As always, I appreciate your help