I use an excellent piece of software called AutoIT (http://www.autoitscript.com). AutoIt is a very flexible easy to use programming language which supports SQLite. I used it to write a csv import program for SQLite. Took me 10 minutes. If you would like to see the source as an example just say.
Cheers, Marek 2009/3/7 Sylvain Pointeau <sylvain.point...@gmail.com>: > from my experience, > sed will read line by line, which is not good for the CSV file.(one field > can be on multiple lines). > > why sqlite is not enhanced to handle fully the csv file format? > > Cheers, > Sylvain > > > On Fri, Mar 6, 2009 at 11:33 PM, John Machin <sjmac...@lexicon.net> wrote: > >> On 7/03/2009 6:16 AM, Rich Shepard wrote: >> > On Fri, 6 Mar 2009, Hans-Martin wrote: >> > >> >> It seems that there is no way to get rid of the embedded CR/LF without >> parse >> >> the complete output. >> > >> > Use sed. That's what it's for. >> >> Has anyone considered that getting rid of the embedded CR/LF is >> destroying information? >> >> Has anyone considered the possibility that SQLite .import could be made >> to support the CSV format? >> >> Alternative: read the CSV file and update the SQLite3 database using a >> scripting language with the appropriate capabilities (Python definitely, >> Perl surely, others ...) >> >> Cheers, >> John >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Don't argue with an idiot; people watching may not be able to tell the difference. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users