AnsweredAssumed Answered

using odbc to send snd retrieve data from Excel

Question asked by ianmanning on Mar 20, 2009

Title

using odbc to send snd retrieve data from Excel

Post

From excel I can access data on our company stock system but I cannot access the stock system from Filemaker.

So I would like to use Excel as an invisible go between. I want to set up a simple excel sheet that will take a value ( Part number) from filemaker and then return another value (price) which it looks up in the stock system.

This sounds simple and straight forward until I try to add the excel sheet to the relationship graph i get an error message stating that "the ODBC source you have selected is not supported"

Does anyone have any ideas what I am doing wrong or any suggestions on how I can achieve this another way?

Thanks

Ian

 

Outcomes