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

by

Posted on by

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

Try Withdata DBBlobEditor, a SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) editor for Windows, Mac, and Linux, Bulk import TXT into SQL Server, East and Fast.

Download DBBlobEditor Download DBBlobEditor

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

Run DBBlobEditor, login to SQL Server.

Batch import txt files into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) - login to SQL Server

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

Batch import txt files into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) - Task Window

then show the wizard.

1. Configure import TXT settings.

Batch insert txt files into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) - config

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

Batch save txt files into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) - import

then you can see importing results

Batch import txt files into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) - view

Bulk import TXT to SQL Server in command line

Save “Bulk import TXT to SQL Server” session, then you can:

Set scheduled tasks for bulk import TXT to SQL Server

You can schedule and automate this converting task by:

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “Bulk import TXT to SQL Server” conversion.
  2. Set scheduled task for “Bulk import TXT to SQL Server” conversion.

FAQ

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