On 9 Dec 2010, at 12:33pm, pyt...@bdurham.com wrote: > Simon, > >> convert your text file to .csv format, and use the SQLite command-line tool >> to make a table out of it. > > Will this technique work with multi-line fields (fields with newlines) > or blobs?
The answer seems to depend on which operating system you're using, and which character you're using for newlines (return or newline or both). Can I suggest you make up a tiny example file, something like 1,"hello" 2,"good bye" and try it ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users