如何将超过 65536 行从 Access 传输到 Excel 2007
如何将超过 65536 行从 Access 传输到 Excel 2007。Excel
2007 方面没有限制，因为新版本支持 Excel 中超过 65536 行。剪贴板即将受到限制。不允许从 Access 导出或复制超过 65536 行。
谢谢
How to transfer more than 65536 rows from Access to excel 2007.
There is no limitaion on the part of Excel 2007 as the new version supports much more than 65536 rows in Excel. Limitation is coming on the part of Clipboard. It is not allowing to export or to Copy more than 65536 rows from Access.
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
数据->进口？
这有什么问题吗？我已经多次使用它来导入数千条记录。
只需定义数据源并导入即可。
Data -> Import?
What's wrong with that? I've used it many times for importing thousands of records.
Just define the data source and import it.
几乎可以肯定这是超时或内存问题。 PHPExcel 对工作表大小的唯一限制是 65,536 行和 256 (IV) 列（使用 Excel5 Writer 时）；或 1,048,576 行和 16,384 (XFD) 列（使用 Excel2007 Writer 时）。
如果您使用 PHPExcel 库，那么您可以更改此行
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
作为
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
然后它允许写入超过 65536 行的记录。
这对我有用。
Almost certainly this is a timeout or a memory issue. The only PHPExcel limit for worksheets size is 65,536 rows and 256 (IV) columns (when using the Excel5 Writer); or 1,048,576 rows and 16,384 (XFD) columns (when using the Excel2007 Writer).
If you are using PHPExcel Library then You can change this line
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
as
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
Then it allows to write records more than 65536 rows.
It works for me.