本文介绍了将Access数据透视表导出到Excel的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好, 我需要你的帮助。我有一个代码将查询导出到excel但我如何添加或实际上我应该添加到现有代码中的代码,以便将数据透视表导出到excel? 到目前为止我的代码是:
Hi everyone, I need your help. I have a code which exports the query to excel but how do I add or in fact what code should I be adding to the existing code for me to export the pivot tables to excel as well? My code so far is:
展开 | 选择 | Wrap | 行号 推荐答案以下代码将数据透视表中的所有数据导出到单个Excel电子表格。指定常量 conBASE_PATH 中的基本路径,以及表名称& .xls将附加到它。请务必使用您自己的表名替换演示名称。这是你要找的吗? The following Code will Export ALL Data within Pivot Tables to individual Excel Spreadsheets. Specify the Base Path within the Constant conBASE_PATH, and the Table Name & .xls will be Appended to it. Be sure to substitute your own Table Names in place of the Demo Names. Is this what you are looking for? 展开 | 选择 | Wrap | 行号
您好ADezii, 非常感谢你的回复。 我仍然对你给我的代码有疑问。 对不起......我是Access的新手。我正在处理的数据库是由离开办公室的程序员之一建立的。 我的代码是这样的吗? Hi ADezii, Thank you so much for your reply. I am still having problem with the codes you have given me. Sorry...I am very new to Access. The database which I am working on is built by one of the programmer who left the office. Do I put your code like this? 展开 | 选择 | Wrap | 行号
Michele,我不完全理解代码行9,10中的语法请解释。 Michele, I do not fully understand the Syntax in Code Lines 9, 10, 31 and 32. Kindly explain. 展开 | 选择 | Wrap | 行号
更多推荐
将Access数据透视表导出到Excel
发布评论