{"id":8430,"date":"2017-08-30T14:19:20","date_gmt":"2017-08-30T14:19:20","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=8430"},"modified":"2017-08-30T14:19:20","modified_gmt":"2017-08-30T14:19:20","slug":"batch-import-rtf-files-into-sql-server-image-varbinarymax-blob-without-programming","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/sqllobeditor\/batch-import-rtf-files-into-sql-server-image-varbinarymax-blob-without-programming.html","title":{"rendered":"Batch import RTF files into SQL Server [IMAGE, VARBINARY(MAX)] (BLOB) without programming"},"content":{"rendered":"<p>Want to batch import RTF (Rich Text Format) documents into  <a href=\"https:\/\/www.microsoft.com\/en-us\/cloud-platform\/sql-server\">SQL Server<\/a>  [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) or [IMAGE, VARBINARY(MAX)] (BLOB) column?<\/p>\n<p>Using <a href=\"https:\/\/www.withdata.com\/sqllobeditor\/\">SqlLobEditor<\/a>, you can import bulk rtf files into  <a href=\"https:\/\/www.microsoft.com\/en-us\/cloud-platform\/sql-server\">SQL Server<\/a>  [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) or [IMAGE, VARBINARY(MAX)] (BLOB) easily and fast, just a few mouse clicks.<\/p>\n<p>Here you can <a href=\"https:\/\/www.withdata.com\/down\/SqlLobEditor.exe\">download<\/a> and install <a href=\"https:\/\/www.withdata.com\/sqllobeditor\/\">SqlLobEditor<\/a>.<\/p>\n<h2>Batch import RTF documents to  <a href=\"https:\/\/www.microsoft.com\/en-us\/cloud-platform\/sql-server\">SQL Server<\/a>  [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) column<\/h2>\n<p> Click &#8220;Start New Task &#8211; Import LOB From Files&#8221; at task dialog.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/lobeditor\/task-list.png\" ALT=\"Batch import rtf files into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB)  - Task Window\" width=\"500\" height=\"373\" style=\"max-width:100%;height:auto;display:block;\"><\/p>\n<p>then show the wizard.<\/p>\n<p>1. Config.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/lobeditor\/batch-import-rtf-config.png\" ALT=\"Batch insert rtf files into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) - config\" width=\"480\" height=\"570\" style=\"max-width:100%;height:auto;display:block;\"><\/p>\n<p>2. Import.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/lobeditor\/batch-import-rtf-import.png\" ALT=\"Batch save rtf files into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB)  - import\" width=\"480\" height=\"570\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>then you can see importing results<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/lobeditor\/batch-import-rtf-view.png\" ALT=\"Batch import rtf files into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB)  - view\" width=\"641\" height=\"598\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<hr style=\"clear: both;\" \/>\n<p><a href=\"http:\/\/www.withdata.com\/sqllobeditor\/\">More about SqlLobEditor &#8211; the tool to batch import RTF documents to SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) column<\/a><\/p>\n<div style=\"clear: both;\">\n<p>30-day free trial <a href=\"http:\/\/www.withdata.com\/down\/SqlLobEditor.exe\"><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/btn_download_green.png\" alt=\"Download SqlLobEditor\" width=\"165\" height=\"50\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/><\/a>US$75.0 <a href=\"http:\/\/www.withdata.com\/sqllobeditor\/purchase.html\"><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/btn_buynow_green.png\" alt=\"Buy SqlLobEditor\" width=\"154\" height=\"45\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/> <\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Want to batch import RTF (Rich Text Format) documents into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) or [IMAGE, VARBINARY(MAX)] (BLOB) column? Using SqlLobEditor, you can import bulk rtf files into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) or [IMAGE, VARBINARY(MAX)] (BLOB) easily and fast, just a few mouse clicks. Here you can download and [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[109],"tags":[97,100,2106,1321,2109],"class_list":["post-8430","post","type-post","status-publish","format-standard","hentry","category-sqllobeditor","tag-blob","tag-clob","tag-rtf","tag-sql-server","tag-store-rtf-in-sql-server-blob-or-clob"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/8430","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=8430"}],"version-history":[{"count":1,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/8430\/revisions"}],"predecessor-version":[{"id":8431,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/8430\/revisions\/8431"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=8430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=8430"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=8430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}