将Access数据透视表导出到Excel [英] Exporting Access Pivot tables to 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的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！