高手jinlai

[ZXJ44485524]

问下高手们 ACCESS数据库的导出功能依赖那些组件

dao360.dll，Interop.Access.dll，Interop.DAO.dll
Access.ApplicationClass oAccess = new Access.ApplicationClass();
oAccess.Visible = false;
try
{
//ACCESS9:
oAccess.OpenCurrentDatabase("C:\\Program Files\\档案管理中心\\Setup\\dzzl.mdb", true, "");
//导出到excel

oAccess.DoCmd.TransferSpreadsheet(Access.AcDataTransferType.acExport, Access.AcSpreadSheetType.acSpreadsheetTypeExcel9, "zonghec", "d:\\地质资料目录综合成果类.xls", true, null, null);
//AcSpreadSheetType.acSpreadsheetTypeExcel11
//导入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();
}

[sunshine_anycall]

up

[kbtjh]

up