Dear Group, I currently have a Dataset that is filled with the results of a SELECT Stored Procedure. (I created a Command for the SP, a DataAdapter for that command, and used that DataAdapter to fill the Dataset)
Now i need to export that Dataset to Excel. I want to do this as automatically as possible. I'd like to avoid the solution of recursing through all the rows in the Dataset, and manually writing the cells in Excel. (And this is the only solution I could come up with so far). If I were using Excel 2002, I could export the Dataset to an XML file (I've already done this), and I could import it into Excel, but I'm using Excel 2000. I've also read about using an XSLT to transform the XMl data into a CSV, or a tab-delimited file, but the problem is that the format of the XML will vary a little depending on what SP I call, and I want this to be generic. If any of you can think of something for this, I'd really really appreciate it. Thanks a lot. Daniel Magliola Cimatic SRL +5411 4787 5311 ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
