Have somebody succeed setting up a API Connection to FMS 17 from Excel?
Data API? That would require coding it in VBA I would imagine.
Easier to do with just plain old ODBC.
Thanks for your answer.
If ODBC is the easy way I keep using it.
Just for info.
Today made a test with Power Query within excel 2016.
I get the data in a worksheet and refreshing is working.
Now looking if it's reliable.
with Data API.
Is that a question or a statement?
As in: "you are still working to try and make it work" or "it is working and continues to work"
user18013 wrote:Today made a test with Power Query within excel 2016.
Keep in mind that Power Query is a Windows-only feature of Excel (at least for now). If you need to deploy this to Macs it may not work.
It was a statement as in "it is working and continues to work".
Thanks for the warning, but we are working in a Windows environment.
Retrieving data ...