Export Peachtree Data Version 6.0

[ABerkowicz]

Does anyone know of a way or tool that I can use to export data from Peachtree Version 6.0 to ultimately end up in SQL table. Are they are add ons to Peachtree to export data? I looked at PawCom briefly and saw that it works for V7 and up.

Thanks,
Angela

 

[dgillz]

I would use crystal reports to export the data to excel, then import it to SQL.

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

http://www.gainfocus.biz

 

[SBTBILL]

I don't think Crystal was available for 6.0, but the data export function was. You can export to csv files which are basically comma delimited files. Data can then either be run through the Enterprise Manager data transformation services import routine or if it needs fixing through a Visual FoxPro program and ADO'ed in.

Problem is that the data that you can export from Peachtree while much better then Quickbooks is not complete.

Bill Couture

 

[dgillz]

Crystal is available for any version of peachtree, provided you have the ddfs.

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

http://www.gainfocus.biz

 

[SBTBILL]

Ok understand Crystal is available. What I ment was that a Crystal Reports for Peachtree with the pre-set data dictionary wasn't.

Bill Couture