DoCmd.OutputTo acOutputQuery的局限性 [英] Limitation of DoCmd.OutputTo acOutputQuery

问题描述

我正在尝试将查询结果输出到excell文件，用户无需通过标准控件。换句话说，如果他们单击表单上的相应按钮，我希望查询结果输出到excell文件。除了excell设置的记录之外，您可以输出多少记录，只允许大约65,000。我可以输出1万条记录，但不能输出24,000条记录吗？

I am trying to output the results of my query to an excell file, with the user not having to go through the standard controls. In other words, I want the query results to get output to an excell file, if they click the appropriate button on a form. Is there a limit on how many records you can output other than the one set by excell, of only allowing around 65,000. I can output 10 thousand records, but not 24,000, any thoughts?

推荐答案

有人对此有什么想法吗？

Anyone have any thoughts about this?

也许你应该尝试使用DoCmd的TransferSpreadsheet方法。

Maybe you should try using TransferSpreadsheet method of DoCmd instead.

也许你应该尝试使用DoCmd的TransferSpreadsheet方法。

Maybe you should try using TransferSpreadsheet method of DoCmd instead.

谢谢，但它仍然根据命令设置的限制将输出大小输出到多行你知道如何控制这个限制吗？

Thanks, but it still size output to many rows based on limit set by command do you know how to control this limit?

这篇关于DoCmd.OutputTo acOutputQuery的局限性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！