OLE DB or ODBC error with Microsoft PowerPivot
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.