AnsweredAssumed Answered

Unable to export to XLSX using FileMaker Pro Version 10.0v2

Question asked by SighGone on Jun 15, 2009
Latest reply on Jul 14, 2009 by TSGal

Summary

Unable to export to XLSX using FileMaker Pro Version 10.0v2

Description of the issue

FileMaker Product(s) involved:FileMaker Pro 10.0v2 (04-14-2009) Operating System(s) involved:Windows Vista SP2Windows Version 6.0 (Build 6002)CPU Type: PremiumPhysical RAM 2,048 Meg (42%) Detailed description of the issue:I'm attempting to export a database table with 323,351 records to an Excel XLSX file.  FileMaker Pro exits Exact steps to reproduce the issue:1. Open database2. File -> Export Records...3. Enter File name of "Contacts"4. Save as type: Excel Workbooks (*.xlsx)5. Click Save button6. Click checkbox next to Use field names as column names in first row7. Worksheet: "Therapy Source Contacts"8. Click on the Continue... button9. Click on the Move All button10. Click on the Export button11. Click on the OK button on the FileMaker Pro information window which states "This export type does not support repeating fields. Only first item from each repeating field will be exported'  Expected Result:FileMaker Pro would create Contacts.xlsx with 313351 records. Actual Result:FileMaker Pro shuts down without any error message after counting down from 313,351 to about 180,000. Exact text of any error message(s) that appeared:N/A Any additional configuration information/troubleshooting that is relevant to the issue:Exports fine to CSV and XLS.  Although the XLS finishes after copying only 65536 records. Any workarounds that you have found:Exported to another format: CSV. 

Outcomes