AnsweredAssumed Answered

Execute SQL to insert data into MYOB via ODBC

Question asked by russbrad on Sep 3, 2012
Latest reply on Sep 3, 2012 by gdurniak

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.

Outcomes