View Single Post
  #4 (permalink)  
Old 08-28-2008, 06:35 PM
NvestWeb NvestWeb is offline
WebProWorld New Member
 
Join Date: Aug 2005
Location: North Carolina
Posts: 13
NvestWeb RepRank 0
Default Re: Exporting XML orders to a CSV format

AJ,

MS-Excel can be an excellent "data pump" to translate disparate data sources. Here's a link on how to use Excel for importing and exporting XML. You can use Excel to import/export to .CSV, too. Although a two-step process, it beats re-keying the data.

HOW TO: Import and Export XML in Excel

As you can see, you can automate this with some light programming (Excel Visual Basic for Applications ), too.

If I misunderstood your steps, let me know.

Peter

Sales is more than just a numbers game...
Reply With Quote