On 2/21/2013 5:34 AM, Gert Van Assche wrote:
I have to import text files into an SQLite table.
The txt files are plain text in UTF-8. They don't contain tabs and the line
ending is CRLF.
One line in the TXT should become one record in the table.
CREATE TABLE Source (Segments);
.import 'test.txt <http://www.datamundi.be/test.txt>' Source
SELECT count(*) FROM Source;
The source text contains 156659 lines but the imported table contains only
65561 records.
If you are on Windows, check that the file doesn't happen to contain a
byte with the code of 26 (aka 0x1A aka ^Z). Such a byte is treated as
end-of-file indicator in text files.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
