RE: Export Access Data to Peachtree

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Paul Sanguinetti (PaulSanguinetti_at_discussions.microsoft.com)
Date: 12/08/04 

Date: Tue, 7 Dec 2004 17:19:04 -0800

It can be done, but requires a lot of code. I've interfaced our maintenance
system, operations reporting system, and a variety of therapy evaluations
systems to both Peachtree and Quickbooks.

You have to use vb code to create tab delimited records in a text file that
mimics the format Peachtree uses in its import/export fuction from the File
menu. The file created can then be imported into Peachtree.

I've also found a site that has an obdc driver for a direct interface to
Quickbooks, but haven't looked for one for Peachtree. I've always shied away
from directly writing records into an accounting system as it tends to bypass
the error checking capabilities that are used in the import/export functions.

I've been able to interface purchase orders, receipts, invoices, inventory
transactions, and payroll (timekeeping) data using this method. Set up a test
company and verify you are getting things in the right spots before you go
live with your process.

Relevant Pages

  • RE: Export Access Data to Peachtree
    ... > mimics the format Peachtree uses in its import/export fuction from the File ... > from directly writing records into an accounting system as it tends to bypass ... > the error checking capabilities that are used in the import/export functions. ... > I've been able to interface purchase orders, receipts, invoices, inventory ...
    (microsoft.public.access.developers.toolkitode)
  • Re: Automating DTS conversion?
    ... I started by using the Import/Export wizard and having it generated a VB ... I would expect that you can import the DTS library using the ActiveX Type ... Microsoft Enterprise manager interface, ... pkg: OleVariant; ...
    (borland.public.delphi.database.ado)