导出数据到Excel的几种方法

1.首先声明，这些方法也都是本人搜集的资料，然后为已所用，程序中不足之处，还请高手指点.

2.网上有好多关于用SQL语句导入导出的例子，这里不再重复写了。

方法1:调用com组件,导出access数据到Excel,就是直接调用access的导出功能,此方法速度超级快

using　 Access;

Access.ApplicationClass　 oAccess　 =　 new　 Access.ApplicationClass();
oAccess.Visible　 =　 false;
try
{
//ACCESS9:
oAccess.OpenCurrentDatabase("d:wcf.mdb",false,"");
//导出到excel
oAccess.DoCmd.TransferSpreadsheet(Access.AcDataTransferType.acExport,Access.AcSpreadSheetType.acSpreadsheetTypeExcel9,"工作表名","d:wcf.xls",true,null,null);
//导入txt
// oAccess.DoCmd.TransferText(Access.AcTextTransferType.acExportDelim,"","Enterprise","d:wcf.txt",true,"",0);
oAccess.CloseCurrentDatabase();
oAccess.DoCmd.Quit(Access.AcQuitOption.acQuitSaveNone);
System.Runtime.InteropServices.Marshal.ReleaseComObject　 (oAccess);
oAccess　 =　 null;
MessageBox.Show("导入成功");
}
catch(Exception　 ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
GC.Collect();
}