I created your schema and saved the single line you provided to a file and it all imported fine:
sqlite> .nullvalue NULL sqlite> .separator ; sqlite> .import text.txt Cliente sqlite> select * from cliente; 1|2005-02-13 00:00:00|FRANCISCO EDNAN SABOIA PONTES |0|R|NEWTON PARENTE|1161|PRO XIMO AO COMETA|JANGURUSSU|FORTALEZA|CE|00000000|78928958334|94006024023|327419 66 |32769280 /34724873 - PUBLICO||1977-08-17 00:00:00|NAOCONVENIADO|NORMAL|SUPERVIS OR|2005-12-29 00:00:00|1|PRE - PAGO LANCAMENTO24 HORAS|2005-04-30 00:00:00|0||0| 0|NULL|.0000|CELULAR-MARIAROSIMEIRE|TIO- CELSO||8861-5632|3276- 1949||CONTRATO DE LOCACAO||0|.0000|NULL|NULL|0|NULL|NULL|.0000|.0000|||NULL|NULL|||NULL| NULL||2005 -12-29 00:00:00|1899-12-30 17:08:25|ADMINISTRAÃ+O|ANGELA|ALTERACAO sqlite> The raw data you provided contains text. The strings are not encased in quotes or anything like that so while the example record was fine, if any of your other strings have a ; in them, I imagine that'll break your import Oen thing, your line ".import datafile.txt Cliente ";" "NULL"" didn't work for me, I used separate commands, .nullvalue and .separator Not sure why, I don't regularly use the command line importer > PLEASE, read my e-mail, i really need help ;-) > > > I am trying to import data from a file using sqlite3 command line, and > the tcl bind. But I aways get error about the Number of Columns. Sqlite > always says that I am trying to put less columns than the number of > columns defined in the table.
