Want to convert TXT (“|” pipe delimited text) file to SQL file?
If you want to import TXT (“|” pipe delimited text) file to SQL Server, see this page: TXT (“|” pipe delimited text) to SQL Server.
If you want to import TXT (“|” pipe delimited text) file to SQLite, see this page: TXT (“|” pipe delimited text) to SQLite.
Using Withdata software Data File Converter, a TXT to SQL converter for Windows, MacOS, and Linux, you can convert TXT (“|” pipe delimited text) to SQL easily and fast.
- Can run in GUI mode, Step by Step, just a few mouse clicks.
- Can run in Command line, for Scheduled Tasks and Streams.
- Convert files locally and privately, avoid uploading large TXT file(s) to online services.
Download DataFileConverter
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
Convert TXT (“|” pipe delimited text) to SQL
Choose TXT file -> Set SQL file -> Convert TXT to SQL
“Start a New Convert” for “TXT to SQL”.
Select From “File” “TXT” To “File” “SQL”.
1. Open source TXT (“|” pipe delimited text) file.
Support large TXT file ( > 4GB ).
Source TXT file’s content is like this:
2. Config target SQL file.
3. Summary.
4. Convert TXT to SQL.
After converting, you can view the output SQL file.
Convert TXT (“|” pipe delimited text) to SQL in command line
Save “TXT to SQL” session, then you can:
- Convert TXT (“|” pipe delimited text) to SQL in Windows command line.
- Convert TXT (“|” pipe delimited text) to SQL in Linux command line.
- Convert TXT (“|” pipe delimited text) to SQL in macOS command line.
Set scheduled tasks for converting TXT (“|” pipe delimited text) to SQL
You can schedule and automate this “TXT to SQL” conversion task by:
1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.