出口访问2010年报告excel 2010 [英] export access 2010 report to excel 2010
问题描述
我收到了大约33,000条记录的报告。 我把报告搞定了，然后我尝试导出到excel，然后我得到一个"Overflow"。错误群组。我们每个月都会运行此报告，之前没有出现此错误。 当我使用功能区中的导出到
Excel选项时，它会选中"选择要导出的数据的目的地"。唯一的文件格式选项是Microsoft Excel 5.0 / 95工作簿和Excel 97-Excel 2003工作簿。 是不是有excel 2010文件格式选项？
如果是这样，我该如何显示该选项。 我只是认为这是报告没有转换的问题，但如果我错了请告诉我。 我没有看到任何数据损坏的地方，因为它上个月有效，我认为excel
文件大小不是问题（或者是它）。
TAK
I've got a report with around 33,000 records. I pull up the report fine and then I try to export to excel and I get an "Overflow" error. We run this report every month and it hasn't had this error before. When I use the Export to Excel option from the ribbon it pulls up the "Select the destination for the data you want to export" and the only file format options are Microsoft Excel 5.0/95 workbook and Excel 97-Excel 2003 Workbook. Isn't there an excel 2010 file format option? If so, how do I get that option to show. I'm just think this is the problem with the report not converting but if I'm wrong please let me know. I don't see where any of the data is corrupt because it worked last month and I don't think the excel file size is an issue (or is it).
TAK
推荐答案
这听起来像你可能需要压缩&修理。它肯定应该工作，是的，有一个Excel 2010版本作为Office 14的一部分。您的Access 2010安装是Office套件的一部分还是独立版本？如果它是独立的，那么
你的电脑上有哪些版本的excel？
This sounds like you may need to compact & repair. It certainly should work and yes there is an excel 2010 version as part of Office 14. Is your installation of Access 2010 part of the Office Suite or a standalone version? If it is standalone then what versions of excel do you have on your pc?
这篇关于出口访问2010年报告excel 2010的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
