1 Reply Latest reply on Jun 29, 2009 7:22 AM by TSGal

    importing xlsx into FMP10 results in all blank fields

    nate999

      Title

      importing xlsx into FMP10 results in all blank fields

      Post

      I converted an Access database with 8700+ records to Excel. The spreadsheet works well and contains all the Access data. When I drop the xlsx spreadsheet onto the FM icon to import it into FM, the processs seems to proceed normally but the result is a blank FileMaker database. All fields are empty except the top row which contain substiture field names (f1, f2, etc). The blank FM database is 8771 records long, just like my Excel spreadsheet. This happens no matter what options I choose for conversion.

       

      I'm using the Trial Version of FMP 10.0 v1 on a Vista machine.

       

      Any suggestions?

       

                 ..Nate

        • 1. Re: importing xlsx into FMP10 results in all blank fields
          TSGal

          nate999:

           

          Thank you for your post.

           

          I can't see your Excel file, so I can't determine what is causing the problem.

           

          Try saving the Excel file as a comma-separated values (CSV) text file.  Then, import the CSV text file into FileMaker Pro.  Does this work?

           

          If the resulting table is still blank, open the CSV text file in a text editor to make sure data exists.

           

          Keep me posted if you still run into difficulty.

           

          TSGal

          FileMaker, Inc.