PDA

View Full Version : [SOLVED] Connecting to Commercial Software



philfer
12-03-2009, 07:29 AM
Hello,

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
Phil

stanl
12-03-2009, 01:32 PM
just ensure Report Services are set up and your stored procs can be generated as Excel files via a Web interface. .02 Stan

ronimark
12-15-2018, 12:54 PM
I'm a first time poster and been struggling with this for a while and hoping to get some advice. As the title says I want to send an automatic email to my contacts who's birthday falls on their birthday which is triggered by a a daily task called Birthday Text as the subject. I have this working with code I found on the net, i.e. the task is triggered and it sends the email.