In my third installment on Excel issues, I proposed writing out Excel XML rather than binary Excel files as one way to avoid both the issues of the Excel driver, and the risks of Excel automation.
Recently I came across a DTS custom task that I wrote in Visual Basic.NET in 2004 that does exactly that, in a very basic single-table "proof of concept" kind of way...in Excel *and* Word XML, thank you very much. I've uploaded the source code here. I suspect that the Excel XML standard has evolved since that time, but someone may find this of interest nonetheless.
-Doug
Posted
Jun 21 2008, 01:17 PM
by
dougbert