Retrieving Peachtree Data
Retrieving Peachtree Data
(OP)
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.
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
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
www.trianglepartners.com
RE: Retrieving Peachtree Data
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
Regards
Flinn
RE: Retrieving Peachtree Data
http://www.multiwareinc.com/pawcom.htm
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
www.trianglepartners.com