Toimport a text into a sqlite: this link could be useful:
http://www.gaia-gis.it/gaia-sins/spatialite-tutorial-2.3.1.html CREATE VIRTUAL TABLE books USING VirtualText(books.txt, CP1252, 1, COMMA, DOUBLEQUOTE, ','); Regards, A. 2015-08-01 11:43 GMT+02:00 Andrea Peri <aperi2007 at gmail.com>: > Hi, > to import from excel and from csv I use the spatialite extension for sqlite. > > With that extension, I import directly an excel table, and to import the csv, > using that extension is possibile tohave a virtual table for text and csv. > https://www.gaia-gis.it/fossil/libspatialite/index > > In the same suite there also the freexl extension. > https://www.gaia-gis.it/fossil/freexl/index > > Regards, > > A. > > > 2015-07-30 19:58 GMT+02:00 Sylvain Pointeau <sylvain.pointeau at gmail.com>: >> 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 >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > -- > ----------------- > Andrea Peri > . . . . . . . . . > qwerty ????? > ----------------- -- ----------------- Andrea Peri . . . . . . . . . qwerty ????? -----------------
