1 Reply Latest reply on Jul 30, 2009 12:54 PM by TSGal

    ODBC problem using excel

    daanvdn

      Title

      ODBC problem using excel

      Post

      Hi,

       

      I've got a FM database with a huge amount of fields (between 600-700, I know it's too much but it was the only possibility). My OS is Windows Xp SP3 and I would like to use MS Excel to grap data from FM by means of an ODBC-link, so i can make pivot tables / charts. I've installed the latest SequeLink driver and configured the FM file in question as an ODBC source as is explained in the manual. I've tested the link and there is no problem there, but several problems keep cropping up, when I try to get the data into excel using the Query Wizard

       

      1) The GUI shows all my tables, but not all fields. I've read somewhere that there might be a limitation to 255 fields? Is this true?

      2) When I click on one of the tables I get an error message: "string data, right truncated. Error in column 4."

      3) When I perform a query and choose to show the data in Excel, I get an error message: ""parse error in sql", alternatively if I choose to edit the query in MS Query I get the same error.

      I've created a test file with some 100 fields (no spaces in the field names, but with numerical characters) and a bunch of empty records. This file is much smaller, but the same problems keep occurring ...

       

      Does anybody have a suggestion because I really need those pivot charts....

       

      Kind regards, 

       

      Thanks

       

      Daan

       

       

         

        • 1. Re: ODBC problem using excel
          TSGal

          daanvdn:

           

          Thank you for your post.

           

          The maximum number of fields that can be referenced at one time is 170 fields.  You will need to perform four or five SELECT statements to select all of the data.

           

          If you use the SequeLink driver that comes with FileMaker, do you get the same error(s)?

           

          TSGal

          FileMaker, Inc.