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 ????? -----------------
