There is a connector you can get to allow direct ODBC connection between MYOB and a SQLServer (and other ) database.
I'm currently building an application where there is going to be nightly transfers of data between a web site (customer supplied info going into MYOB) and MYOB (updated credit limits going up to customer records in the web site) I'm not at my office for another 10 days but if you want i can send you details of how to do it then. If you cant wait that long, contact support at MYOB and ask about a subscription to the connection key for ODBC. (You have to pay something each year to keep the key working). Hope this helps. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Jan 16, 2008 1:04 AM, Rob Parkhill <[EMAIL PROTECTED]> wrote: > Toby, > > I have done this, but it depends on the version of MYOB that you are running > on. My solution works on V 11, and since it has been removed from the > shelves here in Canada, I can't confirm that it would work with any other > verions. > > If that column order will help, I can get this to you. > > Rob > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296719 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
