You're not providing quite enough information, what mechanism (not just ODBC) are you using to transport the data? A DTS/SSIS package? A piece of custom software?
JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...