C#如何快速往Excel中插入数据

1.引用COM组件access10  
 
Access.ApplicationClass  oAccess  =  new  Access.ApplicationClass();  
oAccess.Visible  =  false;  
//ACCESS10:  
oAccess.OpenCurrentDatabase("d://test.mdb",false,"");  
//导入access  
oAccess.DoCmd.TransferSpreadsheet(Access.AcDataTransferType.acExport,Access.AcSpreadSheetType.acSpreadsheetTypeExcel9,"一个表名","d://test.xls",true,null,null);  
//导入txt  
//oAccess.DoCmd.TransferText(Access.AcTextTransferType.acExportDelim,"","一个表名","d://test.txt",true,"",0);  
oAccess.CloseCurrentDatabase();  
oAccess.DoCmd.Quit(Access.AcQuitOption.acQuitSaveNone);  
System.Runtime.InteropServices.Marshal.ReleaseComObject  (oAccess);  
oAccess  =  null;  
MessageBox.Show("导入成功");  
 
这是调用access数据库的导出功能直接导出到Excel文件中,速度超级快,10条数据，只需几秒钟。  
 
相关资料：  
http://blog.youkuaiyun.com/wukong777/archive/2004/10/09/129329.aspx  
http://wier.csse.monash.edu.au/live/file_data/wier_projects/306/codemodule.htm  
http://book.77169.org/ask20/how124372.htm