Withdata Software

Merge and convert multiple pipe delimited text files into one SQL

Want to convert and combine multiple TXT (“|” pipe delimited text) files into a single SQL file?

Using Withdata software Data File Converter, a TXT to SQL merging tool, you can merge multiple TXT (“|” pipe delimited text) files into one SQL file easily and fast.

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 and combine multiple TXT (“|” pipe delimited text) files into a single SQL file

Select source TXT files -> Set SQL file -> Merge multiple TXT files into one SQL file

Click “Start a New Convert” at task dialog.

then show the wizard.

Select From “Files” “TXT” To “File” “SQL”.

1. Select source TXT (“|” pipe delimited text) files.

And config first source TXT (“|” pipe delimited text) file.

2. Config target SQL file.

3. Summary.

4. Merge multiple Pipe files into one SQL file.

After converting / merging, you can view SQL file.

Merge multiple TXT files into one SQL file in command line

Save “Merge TXT to SQL” session, then you can:

Set scheduled tasks for merging TXT to SQL

You can schedule and automate this “TXT to SQL” merging task by:

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

2) Set scheduled task.

FAQ

How long does it take to merge multiple TXT files into one SQL file?
DataFileConverter works fast. It convert millions of rows within a minute.
Is it safe to merge multiple TXT files into one SQL file using DataFileConverter?
Of course! DataFileConverter merge multiple TXT files into one SQL file locally, absolutely safe.
Can I merge multiple TXT files into one SQL file on Linux, Mac OS?
Yes, you can. DataFileConverter has Linux, Mac OS, and Windows version.
Can I merge multiple TXT files into one SQL file in command line?
Yes, you can. DataFileConverter can running in command line, on Linux, Mac OS, and Windows.

More about DataFileConverterTXT to SQL converter