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.