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 DataFileConverter, a TXT to SQL converter, 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, Avoid uploading LARGE TXT file(s) to online services.
- Support Windows, Linux, macOS.
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.