Exporting data from Sage Line 50 into Excel #2. By David Carter
In the first article we looked at the process of getting data out of Sage and into Excel via Sage's File'Send Contents To Excel facility.
When the data came over from Sage, a lot of work was required to clean it up - dates were not real dates, debits and credits were both exported as positive numbers, essential fields were missing.
This, unfortunately, is par for the course - in fact Sage is better than most.