using odbc to send snd retrieve data from Excel
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?