2 Replies Latest reply on Mar 21, 2010 3:48 AM by Ardi

    Exporting Data to SPSS

    Ardi

      Title

      Exporting Data to SPSS

      Post

      Hi,

       

      I'm new to filemaker and am using a trial version of File Maker Pro 11 to design a medical research database.  

      I'm using Mac OSX and the database is finished.

       

      To analyze the data I'm using SPSS (PASW version 17)

       

      However, the excel file that I export or save from filemaker pro cannot be opened in SPSS.  The message I get in SPSS is

      "Error accessing the Excel file.  If the file is open in another application please close it and retry"

       

      I want to ensure the process works before buying the filemaker software.

       

      Any help would be greatly appreciated.

       

      Ardi

       

        • 1. Re: Exporting Data to SPSS
          comment_1

          There have been several reports of issues with Excel files generated by Filemaker. Usually these can be cured by re-saving the file in Excel.

           

          In any case, Excel is not the best choice for an intermediate format. Try one of the text formats (tab or comma separated text or the Merge format) instead.

          • 2. Re: Exporting Data to SPSS
            Ardi

            Thanks for your response.

             

            Both solutions worked fine.

             

            Much appreciated as I've been pulling my hair out over this for most of the day!

             

            Cheers

            Ardi