Le jeudi 30 juillet 2015, John McKown <john.archie.mckown at gmail.com> a ?crit :
> On Thu, Jul 30, 2015 at 1:48 PM, Sylvain Pointeau < > sylvain.pointeau at gmail.com <javascript:;>> wrote: > > > On Thu, Jul 30, 2015 at 8:44 PM, Peter Aronson <pbaronson at att.net > <javascript:;>> wrote: > > > > > Actually there exists an open source tool that convert Excel data into > > > SQLite tables -- the ogr2ogr command line tool of OSGeo's GDAL library > ( > > > http://www.gdal.org/). You do need a version of GDAL built with the > > > SQLite and XLSX and/or XLS drivers. Actually, if you don't mind adding > > > SpatiaLite into the mix, you can make your spreadsheets show up a > virtual > > > tables using the VirtualOGR module. > > > Peter > > > > > > really cool, but I would like to have a solution directly in the sqlite3 > > executable, so it would be available on my mac and on my windows at work > as > > well as everywhere where sqlite can be installed. > > > > > ?I see and understand your desire. But I, personally, don't like the idea. > I really don't want Dr. Hipp and the other developers to be using up their > time trying to put in something that is MS specific. And then trying to > keep it up to date with future, incompatible version of the Excel file > format. I don't use Excel.? > > ?I normally use LibreOffice. And sometimes even Gnumeric. > > ?What might be of some, more generic, help would be if the SQLite > executable could do an IMPORT operation from an ODBC source. This could > address your problem because Excel, at least on Windows, supports being > used as an ODBC target. I don't know about the Mac. The plus of this would > be that would open up a standard interface to SQLite which could use many > other sources such as Oracle, PostgreSQL, MariaDB (MySQL), and anything > else which implements an ODBC source interface.? > > My answer saying that I would like to have it in sqlite implied a correct csv import. In a previous email, I stated that it would be unreasonable to ask sqlite to have an xml parser etc. I just need a import of csv that is working well, not more.
