AnsweredAssumed Answered

OLE DB or ODBC error with Microsoft PowerPivot

Question asked by RandolphDudley on Jul 8, 2013
Latest reply on Jul 9, 2013 by RandolphDudley


OLE DB or ODBC error with Microsoft PowerPivot


     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.