It looks as if one of your test fields is not formatted as a valid nteger or is pperhaps a duplicate.
Try initially loading your data into a table with a column specified as a real number and not defined as the primary key. If it succeeds use the table to search for duplicates and non-integer numbers. Kelly Jones wrote: > I have a text file onenum.txt with just "1234\n" in it, and a db w/ > this schema: > > sqlite> .schema > CREATE TABLE test (foo INTEGER PRIMARY KEY); > > When I import, it fails as follows: > > sqlite> .import onenum.txt test > Error: datatype mismatch > > Is sqlite3 treating "1234" as a string or something? Short of doing > "INSERT INTO test VALUES (1234);", how do I import numbers into > sqlite3's rowid column? [1] > > [1] Since foo is INTEGER PRIMARY KEY, it's just an alias for rowid. > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users