I tested excel 2010 on a windows 7 machine 64 bit. I entered the data, and did a "save as" choosing the type .csv MS-DOS version. All worked out with proper quotes for data fields, and quotes in the data field delimited.
On Friday, July 18, 2014 9:11 PM, Keith Medcalf <[email protected]> wrote: > > >>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 > > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
