AnsweredAssumed Answered

Using Filemaker 16 Pro as an ODBC data source in Excel

Question asked by fazzywazzy on Apr 3, 2018
Latest reply on Apr 4, 2018 by fazzywazzy

Hi. I'm new to this community and not a FileMaker developer. A client of mine is using a FileMaker 16 Server solution. I am trying to build a query in Excel using a combination of data from FileMaker and Sage.

I've made a local copy of the database. I'm working remotely at the moment, and the client has not given remote access to the live system (yet).

I have set up ODBC drivers correctly and have succesfully returned data to Excel (Power Query) on Windows 10 64 bit version.

It seems I need to have the FileMaker database open, or at least the fm xdbc listener running, for the ODBC connection to work.

I was using a FileMaker trial subscription, which has now ended.

Do I need to purchase a FileMaker licence just to open the database to turn the fm xdbc listener on? Or is there another way?

Any help greatly appreciated.