2 Replies Latest reply on Jul 9, 2013 7:35 AM by RandolphDudley

    OLE DB or ODBC error with Microsoft PowerPivot

    RandolphDudley

      Title

      OLE DB or ODBC error with Microsoft PowerPivot

      Post

           Hello all,

           This may not be the appropriate forum for this issue, but perhaps someone has had a similar issue and a possible work around.

           Having some issues with PowerPivot importing data from a Filemaker Database. I have no issue at all importing data into Excel, only with PowerPivot. This happens with a local database or a remote database, served up by FMS. I have triple checked my ODBC drivers, FMS config, firewall, etc- everything works up until the point that PowerPivot tries to do the actual import of the data. The resulting error I get is:

            

           OLE DB or ODBC error: [FileMaker][FileMaker] FQL0001/(1:8): There is an error in the syntax of the query.; 42000.

           An error occurred while processing table 'Contacts'.

           The current operation was cancelled because another operation in the transaction failed.



           Again, I have no issues with Excel's built in data import- only with PowerPivot extension, but a client is very keen to use PowerPivot so I'm exploring the issue as far as it will go. Will post as well to a forum centered around PowerPivot as well. Thanks in advance for any information.

           rd