On 21 Feb 2013, at 12:15pm, Gert Van Assche <ger...@datamundi.be> wrote:
> thanks for the advice, but I cannot work like this. I don't have the > possibility to rewrite the txt files I receive. > If I use the SQLite Expert, I get an error on "double-quote character" or a > "range error"... > > Any other suggestions? What Roger wrote: you write your own software to read in that text file and do one of the following: A) Write your own program which reads that text file line-by-line and uses SQLite API calls to insert appropriate lines into your database. B) Either by writing your own software or by using a spreadsheet program, use the existing text file to prepare another text file with SQL instructions in: BEGIN, INSERT ..., INSERT ..., INSERT ..., END. You then feed this second text file to the SQLite shell tool using the '.read' command rather than the '.import' command. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
