1 Reply Latest reply on Sep 3, 2012 6:24 AM by gdurniak

    Execute SQL to insert data into MYOB via ODBC

    russbrad

      Has anyone successfully used the execute SQL script step to export data from FileMaker to MYOB accounting software via ODBC?

       

      I have created the DSN (windows 7) and have used MYOBs testing app to verify that the DSN is accessing the MYOB data successfully. When I attempt to add the execute SQL script step to a script, FileMaker asks me to authenticate - can anyone tell me what password is required at this point? I have tried the MYOB, Windows and FileMaker passwords without luck.

       

      At this point I just want to know that someone has done this before :-) that would be encouragement enough.