SQLite Forum

Importing delimited file
I am trying to import a tab delimited file that contains 518548 rows into an SQLite table that has 7 columns using the .import command.  The command seems to run fine without any errors but only the first 145741 rows are imported. If I recreate the import file and SQLite table with only 2 columns but the same number of rows, then all the rows are imported.  Is there a size limit for import files?