Adam Alkins wrote:
Hey, Been looking around to do this for a while, haven't gotten concrete information. I'm interested in taking data from Peachtree Accounting 2003 (Which is stored Btrieve DAT files) and importing them into a Postgres SQL database. I have looked around on the net about this, but haven't gotten any concrete methods on doing this. Figured with Pervasive's involvement in PostgreSQL, might have some luck on this list.
Use Perl :) http://search.cpan.org/~dlane/ Which will get you access to the files and then Perl-DBI/DBD to push into PostgreSQL. Sincerely, Joshua D. Drake
Peachtree also stores the DDL (Dictionary) files for the Btrieve database in the directory. I'm not sure what version of Btrieve the files are. Does anyone have any experience in doing this? I read somewhere about Pervasive's SDK for their DB server which can convert Btrieve files to SQL (or something like that), but looking through the SDK and documentation, haven't found any real information. This is just an experimental project, so any commercial solutions to do this really doesn't apply. Regards, -- Adam Alkins http://www.rasadam.com ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
-- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: PLphp, PLperl - http://www.commandprompt.com/
