I have written a function that will export a recordset to .csv It is pretty quick. I can dump out 2000 records with 254 columns in about 2 seconds. Let me know if you would like it.
-----Original Message----- From: Daniel Magliola [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 3:51 PM To: [EMAIL PROTECTED] Subject: [vbhelp] Vb.Net - Export Dataset to Excel 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 '// ======================================================= 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.779 / Virus Database: 526 - Release Date: 10/19/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.779 / Virus Database: 526 - Release Date: 10/19/2004 ------------------------ 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/
