Write to Peachtree with VBA

    Anyone know if it is possible to write code to post Excel data directly to Peachtree using VBA rather than the export/import process?

    Re: Write to Peachtree with VBA?


    I'm sure it's possible, otherwise they wouldn't give away an SDK for free (I think you need to be using a premium edition to get the SDK tho)


    So, you either get the SDK and program it yourself, or go to a 3rd party who's already done it - a quick google found these guys


    http://www.multiwareinc.com/toolkit.html


    To be honest I've never used Peachtree, however I was looking to do this a few yrs back for SUN Accounts & it was easier to buy the 3rd party VBA tool "Vision" for aroung £1,000 a licence than develop something myself.

    Re: Write to Peachtree with VBA?


    Thanks for the reply. I'll try the link. I'll let you know if I come up with anything. I've been searching the internet all day, and can't find a straight answer. Although, I have not been told no, so.... the search continues.

    Re: Write to Peachtree with VBA?


    Oh from what I could see, the answer is most definitely YES.


    My only concern is that if you're not a programmer, the $299 3rd party tools may be your best bet :)

    Re: Write to Peachtree with VBA?


    Yeah, it seems possible to me, too. I would need to determine the database/table layouts, then a simple append ADO/DAO routine should do it, I would think. This is a simple export of invoice info.

    Re: Write to Peachtree with VBA?


    Quote from Zzyzzyth

    I would need to determine the database/table layouts, then a simple append ADO/DAO routine should do it, I would think.


    Don't be too sure. Depends on the database type. It might not accept an ODBC, OLEdb link. That's why I mentioned the SDK. You won't know till you look there

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login