Post reply

Controlling Access / Excel from SQL Server

  • April 8, 2004 at 9:26 am

    #359412

    Hi, this is a questions relating to Excel but principals would be same with Access.

    I am using DTS to create Excel spreadsheets based on templates. I would like to manipulate the left, centre and right headers / footers based on info from SQL Server. E.g. the date / time the DTS package was run (rather than the Excel Print date / time)

    I could allocate this using a macro in Excel but I do not want users to have the Excel macro warning when they open the spreadsheet.

    If I was doing this from Access the answer would be simple, I would simple control Excel using automation in VBA. I am wondering whether it is possible to use automation in SQL Server or is there an alternative. An example would be helpful as I am not sure where to start.

  • April 9, 2004 at 12:32 am

    #502259

    maybe http://www.sqldts.com has what you're looking for

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • April 13, 2004 at 4:29 am

    #502518

    Thanks for the link. I found an example at http://www.sqldts.com/default.aspx?245

    I did not realise that Automation worked in exactly the same way in an ActiveX script as in VBA.

    Regards

    Stefan

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply