Peachtree & DDE (Dynamic Data Exchange)

[rcalbrig]

Are there any information on using DDE to get sales order information out of Peachtree

Want to pull out individual sales orders either by sales order # or by range or dates and then extract to access or directly to a pronto products label printer so we can print (roll stock) labels for each line item on the sales order.

My label software can get access an MS Access database via ODBC

[jhudson]

Save your self infinite headaches and spring for Multiware's PawCom. It is the greatest tool on the planet. Sucks every piece of data out of Peachtree and populates an MSAccess *.mdb in a relational layout. From there you can read the documentation (also sets the standard for documentation) and do virtually anything you want.

Good luck.

[jag]

Just in case you need the link:

http://www.multiwareinc.com

-or-

http://www.multiwareinc.com/pawcom.htm

[rcalbrig]

Can this program take a 25 MB data file for extraction at a time or small snippets of the monthly data?

Doing data exports with a months sales data is taking several hours at the moment using PT2003 export feature.

[jhudson]

Without more detail re: version/sys/network/etc timing would be difficult to say. But my guess is that a 25 meg PT db (folder) would get sucked into Pawcom in less than a couple minutes. You can be selective about what you want to extract, but until one gets familiar with the data structure, I'd just grab it all. For example, if you want sales info, it's likely your going to need inventory info, customer info, perhaps gl or vendor or jobs info. You could then build a complete menu based reporting application in the MSAccess db using Access switchboard manager in virtually no time at all. It even comes with a whole raft of reports. Try it, you'll discover you can't live without it.

Continued good luck.