Withdata Software

Import TXT into SQLite

Want to import data from TXT file to SQLite?

Try Withdata FileToDB, a desktop TXT to SQLite converter for Windows, MacOS, and Linux, Convert TXT to SQLite, Easy and Fast.

Download Withdata FileToDB
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Import data from TXT file to SQLite

Login to SQLite -> Choose TXT file -> Set SQLite table -> Import TXT to SQLite

Choose SQLite and logon.

Click “Wizard – 1 File To 1 Table” at task dialog.

Select the “TXT” file type.

then show the wizard.

1. Open a TXT file.

Support large ( > 4GB ) TXT file.

Here is the file’s content.

2. Select a SQLite table and config fields.

3. Preview data will be in SQLite table.

4. Import TXT data to SQLite.

View imported data in SQLite table

Import TXT to SQLite in command line

Save “TXT to SQLite” session, then you can:

Set scheduled tasks for importing TXT to SQLite

You can schedule and automate this “TXT to SQLite” conversion task by:

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “TXT to SQLite” conversion.
  2. Set scheduled task for “TXT to SQLite” conversion.

FAQ

What is Withdata FileToDB?

Withdata FileToDB is an ETL software can import TXT data to SQLite. Download Withdata FileToDB

How long does it take to import TXT data to SQLite?

FileToDB works fast. It convert millions of rows within a minute.

Is it safe to import TXT data to SQLite using FileToDB?

Of course! FileToDB import TXT data to SQLite locally, absolutely safe.

Can I import TXT data to SQLite on Linux, Mac OS?

Yes, you can. FileToDB has Linux, Mac OS, and Windows version.

Can I import TXT data to SQLite in command line?

Yes, you can. FileToDB can running in command line, on Linux, Mac OS, and Windows.


More about Withdata FileToDB – TXT to SQLite converter

See also:

TXT → SQLite reference

Type mapping

Value kindin TXTin SQLite
Int1234, or right-aligned in a fixed-width columnINTEGER
Bigint9007199254740993INTEGER
Decimal1234.56NUMERIC
Float1.234e+10REAL
Textwritten as-is; padding depends on the chosen layoutTEXT
Long textwritten as-isTEXT
Datewhatever the writer choseTEXT
Binarynot representableBLOB
BooleanY / N, or 1 / 0, or TRUE / FALSEINTEGER

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.

Propertyin TXTin SQLite
port—(file-based)
identifiersNone by convention"double quotes" or [brackets]
row limit—LIMIT n
datesWhatever the writer produced; no convention is guaranteedTEXT (no date type)
long text—TEXT
binaryNot supportedBLOB
separatorWhatever was chosen - often fixed column widths—
encodingNo declaration - UTF-8 works only with a BOM—
typingNone - every field is text—
shapeFree form; a parser has to be told the layoutTables of rows and columns
ceilingNo formal limit—

Command line

SideCommand
SQLitesqlite3 .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.