Convert and combine multiple pipe delimited text files into 1 SQL file

by

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

Using Withdata software DataFileConverter, a TXT to SQL merging tool, you can merge multiple TXT (“|” pipe delimited text) files into one SQL file 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, Avoid uploading LARGE TXT file(s) to online services.
  • Support Windows, Linux, macOS.

Download DataFileConverter Download DataFileConverter

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.

Merge multiple TXT files into one SQL file - task window

then show the wizard.

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

Combine multiple TXT files into one SQL file - select type

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

Convert and merge multiple TXT files into one SQL file - select TXT file folder

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

Generate a SQL file by multiple TXT files - config first source TXT file

2. Config target SQL file.

Merge multiple TXT files into one SQL file - config SQL files

3. Summary.

Create a SQL file by multiple TXT files - summary

4. Merge multiple Pipe files into one SQL file.

Merge multiple Pipe files into one SQL file - convert files

After converting / merging, you can view SQL file.

Convert TXT file to SQL file - view SQL file

Merge multiple TXT files into one SQL file in command line

Save session, and then create .bat file for Windows command line, or .sh file for Linux / macOS.

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.


More about DataFileConverter – TXT to SQL converter

Download DataFileConverter for 30-day free trialDownload DataFileConverter