Scripting Word Document with data that resides in SQL tables, XML file, and or Excel Spreadsheets RRS feed

  • Question

  • I have data loaded into excel spreadsheets, XML documents, and SQL Server tables.  I'd like to generate rich word documents with this data.  The document would include charts,graphs,and other icons that show based on the data.  Which tool, set of tools, programming language or script should I start looking at for this type of process.  Ultimately I'd like to crank out documents similar to what I see is being done with the MAP assessment tool.  However, I'd like to tailor it to present data that I want to pull.  I 'm not sure which forum is best to put this in so I'm placing it here.  Please advise.  One more thing the documents will be generated automatically eventually not always be written by hand.  Purely data driven

    Wednesday, September 30, 2009 2:45 PM