Consulting

Results 1 to 3 of 3

Thread: Connecting to Commercial Software

  1. #1
    VBAX Tutor
    Joined
    Nov 2007
    Posts
    291
    Location

    Connecting to Commercial Software

    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

  2. #2
    VBAX Master stanl's Avatar
    Joined
    Jan 2005
    Posts
    1,141
    Location
    just ensure Report Services are set up and your stored procs can be generated as Excel files via a Web interface. .02 Stan

  3. #3
    VBAX Newbie
    Joined
    Dec 2018
    Posts
    1
    Location
    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.

    Last edited by Aussiebear; 11-25-2021 at 06:53 PM. Reason: deleted link

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •