Peachtree odbc excel

broken image
broken image

They do NOT recommend nor promote direct access to the database itself, as this can violate Sarb-Ox regulations and get some companies in hot water. Sage Software provides a freely available Software Developers Kit which provides for 'proper' access to the PeachTree database.

broken image

Of course, the other side of the coin is that it is YOUR data, and you should have access to it if you want it. As a result, PeachTree slams this door shut for your own protection. Further, the Sarbanes-Oxley Act provides for possible criminal charges against a public company official for such transgressions, so it is a big door to leave open. Unfortunately, PeachTree has locked down access to your accounting data for one simple reason - allowing ODBC access can be dangerous as it violates ALL accounting controls, as you can then directly update ANY value in the database, leaving the door open for possible accounting 'abnormalities'. These new versions of the database engine have a full-fledged ODBC driver which can provide for easy access directly to your PeachTree data for exporting information to other systems. Recently, they upgraded their systems to use newer versions of the Pervasive workgroup engine, specifically Pervasive.SQL V9 and Pervasive PSQL Summit v10. Peachtree for Windows has used the Pervasive database engine for a long time.

broken image