Is there an interface for Peachtree Quatum 2009 to Access 2007?

Posted on 2009-02-13
Last Modified: 2013-11-15
I want to be able to analyze the information in peachtree.  I am not looking to write back into Peachtree from Access.  Is there an application to link the tables or export them access.  Is this a good way to analyze Peachtree.  

I am a financial analyst and need flexibility.  I am confused as to learn Crystal or stay with Access. with interaction of excel.  Any recommendations on that too?

I want to be able to create reports and financial analytical functions such as forecasts, unit costs, trends, financial reports, etc.

Question by:easycapital
    LVL 84

    Accepted Solution

    This one appears to do it:

    As does the Peachtree SDK, if you wanna take the time to learn it:

    As to Access vs Crystal:

    I use both, and Crystal is a more powerful and flexible reporting program, but then you'd expect that since that's the business of Crystal. There are some drawbacks - if you need to distribute these reports to others, there can be some pretty hefty licensing fees through Crystal, and Crystal can be difficult to learn. It is, however, one of the oldest reporting engines out there and one of the best. And remember that Crystal is JUST a reporting engine, nothing more - you cannot interact with it like you could Excel, for example.

    I do a good bit of work for clients in the financial industry, and have found Access, at times, to be lacking in features needed for the massive amounts of data (and calculations) required. I've always been able to work around it, but most often find myself writing unbound reports and using VBA and queries to do this. Crystal probably would have easily been able to handle this, but then it wasn't an option for these reports.

    So - all in all, as with anything involving computers, it comes down to your needs. I personally don't think you can go wrong with Crystal IF it suits your needs.
    LVL 18

    Expert Comment


    Author Comment


    What do you mean by:  "Crystal probably would have easily been able to handle this, but then it wasn't an option for these reports."

    1) I need to do a lot of variance analysis, forecasting based on assumptions & trends analysis, then graphing it, finding out unit costs, monthly averages, etc.  Is something complex in Crystal?  Is there an online educational site, of course, besides probably the one offered by BO, which is probably very expensive and not such a good bang for the buck?

    2) Do you recommend that I learn a different program other than crystal?

    3) I was thinking to go after the business owners and offer them consultant assistance analyzing their business right out of PeachTree, then I think I would be forced to use Crystal I supposed.  Is there another software solution that I could use instead, I have hear horrors with crystal.  I mean whatever report I used for one client, I would like to be able to use it for the next, if it applies.  Would the licenesing issue give me a problem.  I believe every PeachTree user has the crystal reader, am I right?

    LVL 84
    <What do you mean by:  "Crystal probably would have easily been able to handle this, but then it wasn't an option for these reports.">

    I mean the client didn't have Crystal and didn't want to invest in it. This was working with SQL Server data and an Access Frontend.

    First and foremost: I am no Peachtree expert. I've used it in the past, but that's as far as my experience goes with it.

    1) Given your requirements, it would seem to me that Crystal would be a better platform than Access.

    2) I'm only familiar with Access and Crystal, but there are plenty of other reporting platforms out there. ActiveReports is one that seems to be pretty popular, but Crystal is by far the most widely used (since it's been included in VB since the early days).

    3) I wouldn't dream of trying to figure out the Crystal licensing, but so long as THE CLIENT doesn't need to make changes to the layout/format of the report, then you should be okay if Peachtree uses the Crystal viewer. I'm not so sure of that, given this link I found when searching for "peachtree crystal):

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now