共计 872 个字符,预计需要花费 3 分钟才能阅读完成。
导出代码
DoCmd.RunCommand acCmdExportRTF
DoCmd.RunCommand acCmdExportAccess
DoCmd.RunCommand acCmdExportdBase
DoCmd.RunCommand acCmdExportExcel
DoCmd.RunCommand acCmdExportFixedFormat
DoCmd.RunCommand acCmdExportHTML
DoCmd.RunCommand acCmdExportODBC
DoCmd.RunCommand acCmdExportSharePointList
DoCmd.RunCommand acCmdExportSnapShot
DoCmd.RunCommand acCmdExportText
DoCmd.RunCommand acCmdExportXML
导入代码
DoCmd.RunCommand acCmdImportAttachAccess
DoCmd.RunCommand acCmdImportAttachdBase
DoCmd.RunCommand acCmdImportAttachExcel
DoCmd.RunCommand acCmdImportAttachHTML
DoCmd.RunCommand acCmdImportAttachODBC
DoCmd.RunCommand acCmdImportAttachOutlook
DoCmd.RunCommand acCmdImportAttachSharePointList
DoCmd.RunCommand acCmdImportAttachText
DoCmd.RunCommand acCmdImportAttachXML
示例
新建窗体,在窗体上新建命令按钮控件,然后在命令按钮控件的 VBA 代码下写入相对于的导入导出代码。
注意:该方法适用于 2007/2010/2013/2016 的 ACCCESS 版本。
摘自 http://www.accessoft.com/article-show.asp?id=7991