On Thu, Jul 30, 2015 at 1:48 PM, Sylvain Pointeau < sylvain.pointeau at gmail.com> wrote:
> On Thu, Jul 30, 2015 at 8:44 PM, Peter Aronson <pbaronson at att.net> 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.? -- 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