Peachtree is a Btrieve database (about 8 a year old version) and you connect to it directly or though pervasive ODBC. Pervasive ODBC does not come with Peachtree. In fact Pervasive does not even support the version of Btrieve that Peachtree works on.
You will find the peachtree database to be anything but user friendly. You need to print out you file definitions from peachtree, and EVERY transaction is in the JrnlHdr and JrnlRow files. The JrnlRow Type is the key to getting your data - in your case you want the sales data, which you will manipulate to get commission dollars. The file definitions I mentioned will help you with this, in fact without them thi is pretty much impossible.
Please let me know if you have any questions.
Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com