0 Replies Latest reply on Mar 20, 2009 6:08 AM by ianmanning

    using odbc to send snd retrieve data from Excel

    ianmanning

      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