Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Retrieving Peachtree Data

Retrieving Peachtree Data

Retrieving Peachtree Data

I have a JAVA application that I would like to pull Peachtree data into.  I have downloaded and installed an ODBC driver and successfully connected to the Peachtree database (I connected to Index.DDF, from what I read that seems to be right) via Sun's JDBC-ODBC bridbe.

Now I need to access the data, however I can't figure out what commands to use to do simple things like:

list tables, describe tables, etc.

Maybe I'm off-base, but I thought that Btrieve could be queried via SQL syntax.  Basically, I need to figure out what tables hold the data I'm looking for (Generel Ledger info basically).

Any help would be greatly appreciated.

RE: Retrieving Peachtree Data

Peachtree uses btrieve 6.15 which is a 10 year old technology which pre-dates SQL.  You are out of luck.

In addition, the .ddfs only expose part of the data files (and some files are not exposed at all) so even when you connect to the database natively such as in crystal reports, you are limited.

If you have a specific question about a specific file/table, post it and I will see if I can help.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

RE: Retrieving Peachtree Data

Well that would explain why the software I'm trying to use to view the data keeps crashing.

How do you extract data from the database?  Could I read it in as a string and parse it?  I've read about other extracting peachtree data, so I'm curious as to how they are doing it.

Thanks again for the help.

RE: Retrieving Peachtree Data

You can select certain data using Pervasive SQL (http://www.pervasive.com).  They have a trial version there for you to test.  So yes it can be queried via SQL (through ODBC).  You just don't have any access to write to the data, and some tables are left out.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close