Import Excel .xlsx into Filemaker 10 on a Mac
Filemaker 10.0v1 (Mac) Operating System Involved: Mac 10.5.62.4GHz Intel Core Duo 22 GB 667 MHz DDR2 SDRAM Filemaker crashes when attempting to import large Excel .xlsx files. I have attempted several times to import a 67.1mb file (760,000 rows / 21 columns). Filemaker never gets to the point of import; it goes to thefirst importing screen, “Importing From” but never goes beyond that point &eventually crashes. The work around has been to import files no more than100,000 lines.
Thank you for your post.
A similar problem has already been reported, and our Development and Software Quality Assurance (Testing) departments are aware of this issue. Until this gets changed, one workaround is to export the Excel file to a text file (CSV or tab delimited) and then import that file into FileMaker Pro 10.