Home Forums Article Discussions Article Discussions by Author Discuss content posted by Wayne Sheffield Automating Excel from SQL Server RE: Automating Excel from SQL Server

  • August 21, 2009 at 2:04 pm

    #1043142

    david.c.reynolds (8/21/2009)

    Wayne,

    This is a very fascinating article. I have always wondered it there was a way to write data from SQL directly into an Excel Spreadsheet.

    However, I followed your article's instructions and was not successful in getting the process to work. Can you suggest what I might be doing wrong?

    Not without more information about what kind of problems / errors you're having.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2