>Mostly the problems experienced by people is that they make some home- >brew CSV importer that does not realise how to correctly read >output from a standards-based exporter such as Excel, and then try to >change things like separation or quoting methods to "fix" it >after the fact.
Which version of Excel produces standard-compliant CSV exports? As far as I have ever been able to tell, Excel produces the most broken CSV files to be found anywhere. Of course, I haven't used any of the "not-of-my-responsibility or under-my-control" (pronounced "cloud" by the marketroids) versions, nor anything later than the 2010 versions. Most software designed to use Excel produced CSV files (or to produce CSV files for use by Excel) have a "Use Excel Format" to handle Excel's idiosyncrasies. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
