I use the Ruby scripting language and its abundance of libraries to read excel files then write the output to sqlite. Those libraries, whether they r/w csv or excel files are robust, sometime robust beyond belief. They are likely more robust than what applications developers write into their apps. The libraries are maintained, and can be enhanced by the open source community. Lots of good stuff out there.
Sqlite is a db is awesome. Let's leave the sqlite guys do what the sqlite guys do best. On Thu, Jul 30, 2015 at 2:47 PM, John McKown <john.archie.mckown at gmail.com> wrote: > On Thu, Jul 30, 2015 at 12:58 PM, Sylvain Pointeau < > sylvain.pointeau at gmail.com> wrote: > > > I understood from the mailing list, that CSV is not a defined format, > then > > let's propose another format, well defined, the Excel one (which is in my > > experience a format to is good every time I had to exchange CSV files). > > > > Then why don't you propose an import of CSV from Excel (or similar)? > > csv(excel) > > > > is it possible? in a lot of cases, I cannot use sqlite (executable) > because > > of the lack of a good CSV import. It would really great if this could be > > addressed. > > > > Best regards, > > Sylvain > > > > ?I am replying to your original message rather that later ones because I'm > curious about the CSV file which is giving you a problem. Using the sqlite3 > command on Linux Fedora 22 (64 bit), I get the following (transcript): > > $sqlite3 > SQLite version 3.8.10.2 2015-05-20 18:17:19 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use ".open FILENAME" to reopen on a persistent database. > sqlite> create table test(name1 text, name2 text, name3 text); > sqlite> .mode csv > sqlite> .import ./test.csv test > sqlite> .mode lines > sqlite> select * from test; > name1 = name1 > name2 = name2 > name3 = name3 > > name1 = line1a > name2 = line1b > name3 = line1c > > name1 = line2"a > name2 = line2b > name3 = 'line2b' > sqlite> .quit > joarmc at mckown5 2015-07-30T14:43:21 ~/junk > $cat test.csv > name1,name2,name3 > "line1a",line1b,line1c > "line2""a",line2b,'line2b' > joarmc at mckown5 2015-07-30T14:43:25 ~/junk > ? > > > > -- > > Schrodinger's backup: The condition of any backup is unknown until a > restore is attempted. > > Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. > > He's about as useful as a wax frying pan. > > 10 to the 12th power microphones = 1 Megaphone > > Maranatha! <>< > John McKown > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
