Bernard McNeill wrote: > If it is required to import NULL values into an Sqlite table field, can > this be done
No; the .import commands imports everything as text. (This can result in numbers in columns that have numeric affinity.) To get NULL values, UPDATE the table afterwards. Regards, Clemens