Home Forums Article Discussions Article Discussions by Author Discuss content posted by M. Deschene How to Dynamically and Iteratively Populate An Excel Workbook from SQL Server RE: How to Dynamically and Iteratively Populate An Excel Workbook from SQL Server

  • January 9, 2008 at 1:37 pm

    #766393

    --SQL Server and call xp_cmdshell to modify/re-massage/rename/move/.. your xls file.

    how do you do this? i am using xp_cmshell to output data from a sql table to different tabs in excel. I only get the last set of data in the cursor in the first tab