I guess it’s the csv file I am trying to import causing the problems: Below I copied 10 (identical) records including the header. Hi, the hail0-2002.csv works fine with me too. Afterwards I was able to see where the import jumped columns and I could manually remove the linebreaks in Excel. In the previous version the import went pretty fast and succeeded. For me the previous version (without the remove all spaces bug) was more workable than this version. I know CSV files are often unreliable, I have bumped into these same issues when writing my own import tools. Performance might not be an issue for smaller files (which would normally be the case). The previous version took only 2 or 3 minutes. I started import, went away and came back after half an hour and the import was only at 52%. I have a very large (third party) csv file, 104000 records. I also have a version of this csv file which I have changed to a pipe separated file (field1|field2|field3|etc…) and I didn’t receive the error on this file, but I noticed the import is now very slow. I received this message with the original CSV file formatted like this: “field1”,”field2”,”field3”, “etc…”. I would like to see the record number in this message so I am able to correct the csv file. Message from database engine: table table1 has 39 columns but 40 values were supplied”. I tried the build below and I had some problems with it: I received a message: “Error importing data.

Sqlite database browser csv import slow