Batch import txt files into SQL Server TEXT / NTEXT / VARCHAR(MAX) / NVARCHAR(MAX)

Want to batch import TXT (Text) documents into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) or [IMAGE, VARBINARY(MAX)] (BLOB) column?

Using DBBlobEditor, you can import bulk txt files into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) or [IMAGE, VARBINARY(MAX)] (BLOB) easily and fast.

• Step by step, just a few mouse clicks.
• Support schedule and automate converting task.
• Support Windows, Linux, macOS.

Download DBBlobEditor
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

Batch import TXT documents to SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) column

Run DBBlobEditor, login to SQL Server.

Click “Start New Task – Import LOB From Files” at task dialog.

then show the wizard.

1. Configure import settings.

2. Bulk import TXT files to SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB).

then you can see importing results

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task.

FAQ

More about DBBlobEditor – TXT to SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) importer