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.