Want to convert TXT file to SQL file?
If you want to import TXT file to SQL Server, see this page: TXT to SQL Server.
If you want to import TXT file to SQLite, see this page: TXT to SQLite.
Using Withdata software DataFileConverter, a TXT to SQL converter, you can convert TXT 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 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 file.
Support large TXT file ( > 4GB ).
Don’t worry about the delimiter, DataFileConverter will automatically determine the delimiter, includes comma, tab, colon, semicolon, pipe, hash (octothorpe), slash, asterisk, white space, and you can also enter a delimiter.
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 to SQL in command line
Save “TXT to SQL” session, then you can:
- Convert TXT to SQL in Windows command line.
- Convert TXT to SQL in Linux command line.
- Convert TXT to SQL in macOS command line.
Set scheduled tasks for converting TXT 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.