Batch import TXT into SQLite TEXT

Want to batch import TXT (Text) documents into SQLite TEXT (CLOB) column?

Try Withdata DBBlobEditor, a SQLite TEXT (CLOB) editor, Bulk import TXT into SQLite, East and Fast.

Can run in GUI mode, just a few mouse clicks.
Can run in Command line, for Scheduled Tasks and Streams.
Support Windows, Linux, and macOS.

Download DBBlobEditor

Batch import TXT documents to SQLite TEXT (CLOB) column

Run DBBlobEditor, login to SQLite.

Batch import txt files into SQLite TEXT (CLOB) - login to SQLite

Click “Start New Task – Import LOB From Files” at task dialog.

Batch import txt files into SQLite TEXT (CLOB) - Task Window

then show the wizard.

1. Configure import TXT settings.

Batch insert txt files into SQLite TEXT (CLOB) - config

2. Bulk import TXT files to SQLite TEXT (CLOB).

Batch save txt files into SQLite TEXT (CLOB) - import

then you can see importing results

Batch import txt files into SQLite TEXT (CLOB) - view

More about SQLite TEXT (CLOB) importer

Download Withdata DBBlobEditor

TXT → SQLite reference

Type mapping

Value kind	in TXT	in SQLite
Int	`1234, or right-aligned in a fixed-width column`	`INTEGER`
Bigint	`9007199254740993`	`INTEGER`
Decimal	`1234.56`	`NUMERIC`
Float	`1.234e+10`	`REAL`
Text	`written as-is; padding depends on the chosen layout`	`TEXT`
Long text	`written as-is`	`TEXT`
Date	`whatever the writer chose`	`TEXT`
Binary	`not representable`	`BLOB`
Boolean	`Y / N, or 1 / 0, or TRUE / FALSE`	`INTEGER`

Dialect differences

TXT is a file format and SQLite is a database server, so the target has to be told the types the file never carried – the rows below are where the two sides diverge.

Property	in TXT	in SQLite
port	`—`	`(file-based)`
identifiers	`None by convention`	`"double quotes" or [brackets]`
row limit	`—`	`LIMIT n`
dates	`Whatever the writer produced; no convention is guaranteed`	`TEXT (no date type)`
long text	`—`	`TEXT`
binary	`Not supported`	`BLOB`
separator	`Whatever was chosen - often fixed column widths`	`—`
encoding	`No declaration - UTF-8 works only with a BOM`	`—`
typing	`None - every field is text`	`—`
shape	`Free form; a parser has to be told the layout`	`Tables of rows and columns`
ceiling	`No formal limit`	`—`

Command line

Side	Command
SQLite	`sqlite3 .dump`
SQLite (load)	`.import (sqlite3)`

Convert your data online, free

Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.