If you are working with JET REPORTS in Excel and you find that the COMPANY field will not populate and you receive the following message when you click the TEST CONNECTION button:
THE REQUIRED DYNAMICS NAV CLIENT EXECUTABLE (FINSQL.EXE) COULD NOT BE FOUND IN “.
then you most likely have not populated your JET > DATA SOURCE > GENERAL > DYNAMICS NAV CLIENT FOLDER path. When using Jet 32bit on Windows 7 64bit, you should use
C:\PROGRAM FILES (X86)MICROSOFT DYNAMICS NAV\60\CLASSIC
See the screen shots below for more details.