We help IT Professionals succeed at work.

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

Medium Priority
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.

Watch Question

Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts



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?

Scott McDaniel (EE MVE )Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014

<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):

Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.