Along the lines virtual table, check out "Text File Reader for SQLite" at https://github.com/elau1004/TFR4SQLite/wiki
Hope it meet some or all the needs dealing with importing text. file Since it is virtual table, one need to select the text and insert it into a table. -----Original Message----- From: Andrea Peri <aperi2...@gmail.com> To: General Discussion of SQLite Database <sqlite-users at mailinglists.sqlite.org> Sent: Sat, Aug 1, 2015 2:47 am Subject: Re: [sqlite] CSV excel import 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 ????? ----------------- _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
