Re: Any reason to prefer XML (SMDX) to Excel or CSV

Posted by Zuluaga, Juan on Jan 27, 2013; 4:09pm
URL: http://spssx-discussion.165.s1.nabble.com/Any-reason-to-prefer-XML-SMDX-to-Excel-or-CSV-tp5717720p5717737.html

I would ask them for a sample of the same data in all formats.

A database I use for my work produces "xls" files that are not really xls but an xml that Excel can read, most of the time.

SPSS can't read them too well. So I convert them to true Excel and then to csv.

I prefer to have csv, but my files are very simple, flat, no fancy structure,
and I need to keep them for archival purposes, sure that they can be read in 25 years. No opaque binaries, but text.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD