Date: 02/04/08 (Web Development)    Keywords: asp

I'm making a windows appication in VB.NET (note, NOT ASP.NET) and I was wondering if anyone has any idea of how to open a new excel file and insert a table into it from a datagridview (or a dataset).

I was trying to do it with ADO.NET with an ACE 12.0 connection, but no dice.

Does anyone have a cool function to help me out?

VB.NET 2005
Windows Excel 2007

Source: http://community.livejournal.com/webdev/464576.html