Home Forums SQL Server 2005 T-SQL (SS2K5) SQL 2005 into designed Excel via Stored Procedure. RE: SQL 2005 into designed Excel via Stored Procedure.

  • August 6, 2013 at 2:11 pm

    #1639114

    SGT_squeequal (8/6/2013)

    HI I have just implimeted something a little similar in excell however, instead of exporting from SQL i import from excel.

    I created a button on spreadhseet then create some VBA to open a connection and then populate a worksheet, works wonders

    😀

    Thanks a lot - it looks cool indeed! But my problem is that the Excel file will be sent to clients, which won't be able to access customer's SQL server.

    Thanks again!