Convert pipe delimited text to SQL in a few clicks

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

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.

2) Set scheduled task.

---

More about DataFileConverter – TXT to SQL converter

• 
• 
•