I have tried to create a Data Tools Link called 'test' to excel but when activated get the error message 'Unable to set one or more links to active due to insufficient/invalid information. Setting them to inactive.' If I remove the WHERE statement from the SQL String then I dont get the error message but I dont get a new tab in Properties either. Screen shot of link attached. I'm using Navis Simulate 2013, Fabrication 2013, Office 2010, WIndows 7 all 64 bit. Can anyone tell me what I'm doing wrong. Many thanks
It was written for the 2009 version so some things are in different places, e.g. Samples folder instead of Examples folder, but it looks like you should be able to adjust the steps for the 2013 version, and get a working connection setup to test.