Hi. I have scanned the list archives and Googled. I may have missed something, but what I found was not sufficiently general or robust for my needs.
Happily, sqlite has a very nice .output mode for CSV. It correctly double-quotes fields when they contain a space or a comma, and it correctly 'escapes' double-quote literals as "". Great! I need to go the other way. I don't see an inverse .import mode in sqlite to handle the completely general CSV syntax. As anyone who has ever tried knows, parsing compliant CSV is a lot harder than writing compliant CSV. I'm hoping someone will (please) tell me I missed something in the sqlite docs. Otherwise, I guess I'll be using python's csv module to turn my CSV file into SQL insert statements. This is likely to be an infequent task, but it has to be done perfectly. So if someone knows of a command-line tool to turn CSV into SQL inserts, I would appreciate that too. Thanks, Carlos _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users