SQLite Forum

Problem importing .txt file
Login

Problem importing .txt file

(1) By bstahl on 2021-06-16 13:49:14 [source]

Hello,

I'm trying to import a txt file into SQL using DB Browser, but am having problems doing so. The file is 1.3 million rows, yet it is only importing about 650K rows. I'm trying to figure out why it's cutting off about half of my data, but it's not providing me a report showing any errors -- or at least no report that I can see.

Any suggestions on what I'm doing wrong? The TXT file uses "	" as field separators. It also gives me the option of selecting "Quote Characters" -- but I don't know what that is?

Thank you for your help, Brandon

(2) By Larry Brasfield (larrybr) on 2021-06-16 14:10:18 in reply to 1 [link] [source]

This forum is for discussion regarding the SQLite library. "DB Browser" and its features or quirks are off-topic here.

You should consult DB Browser docs and RFC 4180.