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.
