1 Reply Latest reply on Jan 22, 2009 2:50 PM by TSGal

    Import Excel .xlsx into Filemaker 10 on a Mac

    hwerlin

      Summary

      Import Excel .xlsx into Filemaker 10 on a Mac

      Description of the issue

      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.  

        • 1. Re: Import Excel .xlsx into Filemaker 10 on a Mac
          TSGal

          pstamper:

           

          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.

           

          TSGal

          FileMaker, Inc.