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

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

Select the “TXT” file type.

then show the wizard.

1. Select a folder that constains TXT files.

Support large ( > 4GB ) TXT files.

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