Is there any walkthrough about MS Excel Automation in MS Visual Studio 2005?
I already use Automation in Excel using MSVS2003 but it takes aroung 10min to fill a worksheet w/ more than 1,000 rows from a dataset.
It is very slow because I insert text to cells 1-by-1, is there a way to do it faster?

I've heard there is a new way in automating in VS2005.
I'm using MS Visual Studio 2005 Team Systems and MS Office 2003 so I think I have all the tools I need.

It is ok if it is in VB or C#, or using MS Office Tools.

Thanks,