Withdata Software

Bulk import TXT files into SQLite tables at one time

Want to bulk import TXT files into SQLite tables at one time?

Using Withdata software File To DB, a TXT to SQLite converter for Windows, MacOS, and Linux, you can bulk import TXT files into SQLite tables in one go.

Download FileToDB Download 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

Bulk import TXT files into SQLite tables

Login to SQLite -> Choose TXT files -> Set SQLite tables -> Import TXT files to SQLite tables

Choose SQLite and logon.

bulk import TXT files into SQLite  tables - Choose SQLite and logon

Click “Wizard – N Files To N Tables” at task dialog.

bulk import TXT files into SQLite  tables - task window

Select the “TXT” file type.

bulk load TXT files into SQLite  tables - select file type

then show the wizard.

1. Select a folder that constains TXT files.

Support large ( > 4GB ) TXT files.

bulk import TXT files into SQLite  tables - select a folder

2. Config first TXT file importing options.

3. Set “Import Type”.

4. Map SQLite tables to TXT files.

5. Summary. Set “Convert Rows” and “Skip Rows” if need.

6. Import TXT files to SQLite tables, 1 file to 1 table, one by one.

View imported data in SQLite table

Bulk import TXT files into SQLite tables in command line

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

Set scheduled tasks for bulk importing TXT files into SQLite tables

You can schedule and automate this converting task by:

1) Save session and create .bat (Windows) or .sh (Linux/macOS)

2) Set scheduled task.

FAQ

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 FileToDBTXT to SQLite converter