Roger,
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?
thanks
gert
2013/2/21 Roger Binns <rog...@rogerbinns.com>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 21/02/13 02:34, Gert Van Assche wrote:
> > Does anyone see something obvious I'm doing wrong?
>
> There is no need to bash the SQLite shell into what you are trying to do.
> You can write your own code to read your file and insert each row into
> the database.
>
> Another option is to convert the data file into SQL commands. Place
> "BEGIN;" at the beginning of the file, and "END;" at the end of the file,
> and then precede each line with "INSERT INTO Source VALUES('", double up
> any single quotes in the line, and append "';". (That is essentially what
> the .import command is doing behind the scenes, but it tries a lot harder
> to find separators, count/enforce number of columns, deal with end of line
> etc.)
>
> Roger
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.11 (GNU/Linux)
>
> iEYEARECAAYFAlEl/9kACgkQmOOfHg372QSx2gCg49DGhrLuSIelDYMn0RAPe+GH
> EHkAoJgzYZmyVEUGUcBNbWDxq90s8a5q
> =koQD
> -----END PGP SIGNATURE-----
> _______________________________________________
> 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
