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

    Execute SQL to insert data into MYOB via ODBC


      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.