I have a MS Access report that is output to a text file. What is the best way to transform what I need into XML or the MS Access report into a tabular format?
For example:
The report is grouped by state. I need to denormalize the group and have the state repeat as a column or field.
