Home Forums Article Discussions Article Discussions by Author Discuss content posted by Thomas Stricker Using SQL Server as a Source with for an Excel Application RE: Using SQL Server as a Source with for an Excel Application

  • May 17, 2018 at 9:51 am

    #1990871

    Leo Cohn - Thursday, May 17, 2018 9:15 AM

    Well, the point of my suggestion that you evaluate the Data Pig approach is that eliminates VBA and the connectivity used is built into Excel.  There are no "add-ins" and, if there are no user-set parameters, you do not need any VBA.
    I am merely suggesting an approach that I have used extensively over a number of years that is easy to implement.

    Regards,
    Leo

    I had a quick look at Data Pig.  I think our applications are a bit different.  We're doing canned reports with user specified parameters.  It appears to me that Data Pig is more of an ad-hoc data access tool.  I didn't mean to imply I had anything against the Data Pig approach.