Help getting excel/csv file into SQLite? please help
Noob here. What's the best way to import an excel / csv file into SQLite? Whenever I try I get an error stating "Could not add database." Thank you !!
.import (in the CLI shell) is your friend. But don't try to import an Excel file, just .import the tab-separated value format Excel is willing to produce. For that, first tell the shell: .mode tabs .
sqliteman will also import excel files for you, if you are on Linux or you are prepared to build it for your operating system from the sources. It gives you a few more choices for formats, although I haven't tested the MS Excel XML format since I forked it from pvanek's version. The CSV-like format certainly works. Somewhere I have code to import the Psion database format as well, although it isn't in the published sources.