Problem importing CSV files

[dfgtec]

Please answer the questions below, it helps us to track the issue.

1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): SQLite 3.40.0

2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): Build 276 (Windows - trial license)

3. The steps to reproduce this issue: CSV export from Microsoft Excel (2016) using CSV UTF-8 option. Importing into new table fails - only 42 rows imported.

After import there was a pop-up dialog: Error - The CSV file was truncated unexpectedly, please check the file encoding before importing.

From the console log: -- 2024-09-07 23:56:12.9128 CREATE TABLE "100-row-sample-data" ("Filed" text,"Region" text,"Company" text,"Registration #" text,"Function" text,"ID" text,"Rule" text,"Section" text,"Assessment" text,"Method" text,"Report Date" text,"Start Date" text,"End Date" text,"Fixed Date" text,"Done Date" text,"Description" text,"Description of Issue" text,"Description of Fix" text,"Other Note" text);

-- 2024-09-07 23:56:12.9368 SELECT * FROM "100-row-sample-data" LIMIT 1 OFFSET 0;

-- 2024-09-07 23:56:35.2431 -- Can't log this query because it's too big!

I have successfully imported this CSV into a sqlite db/table using other SQL software so I'm "assuming" it is not a limitation of sqlite.

Noted: If the bug is related to data, please attach an example SQL data. Sample CSV file attached:

100-row-sample-data.csv