On Thu, Jul 30, 2015 at 8:07 PM, Richard Hipp <drh at sqlite.org> wrote:
> > Then why don't you propose an import of CSV from Excel (or similar)? > > csv(excel) > An Excel-to-SQLite converter utility sounds like it would be a great > open-source project. Why don't you start it up? > -- > D. Richard Hipp > drh at sqlite.org I have made a lot of utilities for sqlite, and one of them is a csv2db for sqlite. it is not so practical because: - it needs to be recompile for the platform (windows in my case and I didn't have any compiler) - the program is external to the sqlite3 CLI, therefore we need to mix sql script and bash scripts. but I can give you the source code if you want, it is however written in c++. actually it was available in gitorious but it closed. I have to find time to make it again available on github. My point is that I have seen so many emails regarding this incorrect csv import, that it would be so easy for us if it just simply works in the CLI and delivered in standard in the sqlite3 executable. Best regards, Sylvain
