{"id":10152,"date":"2025-03-15T08:28:12","date_gmt":"2025-03-15T08:28:12","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=10152"},"modified":"2025-03-15T09:28:11","modified_gmt":"2025-03-15T09:28:11","slug":"access-import-json-files","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/dbblobeditor\/access-import-json-files.html","title":{"rendered":"Batch import JSON files into Access MEMO"},"content":{"rendered":"<p>Want to batch import JSON documents into  <a href=\"https:\/\/products.office.com\/access\">Access<\/a>  MEMO (CLOB) or OLE Object (BLOB) column?<\/p>\n<p>Using <a href=\"https:\/\/www.withdata.com\/dbblobeditor\/\">DBBlobEditor<\/a>, you can import bulk json files into  <a href=\"https:\/\/products.office.com\/access\">Access<\/a>  MEMO (CLOB) or OLE Object (BLOB) easily and fast.<\/p>\n<ul>\n<li>Step by step, just a few mouse clicks.<\/li>\n<li>Support schedule and automate converting task.<\/li>\n<li>Support Windows, Linux, macOS.<\/li>\n<\/ul>\n<p><a href=\"#download-top\" onclick=\"dtv.style.display = 'block';\">Download DBBlobEditor<\/a>  <a href=\"#download-top\" onclick=\"dtv.style.display = 'block';\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/download_3.jpg\" alt=\"Download DBBlobEditor\" width=\"80\" height=\"22\" style=\"max-width:100%;height:auto;\" \/><\/a> <span id=\"dtv\" style=\"display: none;\"><br \/>\n<a href=\"\/download.php?app=DBBlobEditor&#038;ver=win64\">Windows 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBBlobEditor&#038;ver=win32\">Windows 32 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBBlobEditor&#038;ver=deb\">Linux .deb (For Debian, Ubuntu) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBBlobEditor&#038;ver=rpm\">Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBBlobEditor&#038;ver=pkg\">MacOS 64 bit<\/a><br \/>\n<\/span><\/p>\n<h2>Batch import JSON documents to  <a href=\"https:\/\/products.office.com\/access\">Access<\/a>  MEMO (CLOB) column<\/h2>\n<p> Run <a href=\"https:\/\/www.withdata.com\/dbblobeditor\/\">DBBlobEditor<\/a>, login to Access.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/logon\/choose_access_logon.png\" ALT=\"Batch import json files into Access MEMO (CLOB) - login to Access\" width=\"430\" height=\"443\" style=\"max-width:100%;height:auto;display:block;\"><\/p>\n<p> Click &#8220;Start New Task &#8211; Import LOB From Files&#8221; at task dialog.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/lobeditor\/task-list.png\" ALT=\"Batch import json files into Access MEMO (CLOB)  - Task Window\" width=\"500\" height=\"373\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>then show the wizard.<\/p>\n<h3>1. Configure import settings.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/lobeditor\/batch-import-json-config.png\" ALT=\"Batch insert json files into Access MEMO (CLOB) - config\" width=\"480\" height=\"570\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<h3>2. Bulk import JSON files to  <a href=\"https:\/\/products.office.com\/access\">Access<\/a>  MEMO (CLOB).<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/lobeditor\/batch-import-json-import.png\" ALT=\"Batch save json files into Access MEMO (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=\"https:\/\/www.withdata.com\/images\/lobeditor\/batch-import-json-view.png\" ALT=\"Batch import json files into Access MEMO (CLOB)  - view\" width=\"636\" height=\"601\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>You can schedule and automate this converting task by: <\/p>\n<p><p><a href=\"https:\/\/withdata.com\/dbblobeditor\/cmd.html\" target=\"_blank\">1) Save session and create .bat file.<\/a><\/p>\n<p><a href=\"https:\/\/withdata.com\/dbtodb\/schedule-task.html\" target=\"_blank\">2) Set scheduled task.<\/a><\/p>\n<h2 id=\"faq\">FAQ<\/h2>\n<div><a href=\"#faq\" onclick=\"a2.style.display = 'block';\">Is it safe to import JSON files to Access MEMO (CLOB) using DBBlobEditor?<\/a><\/div>\n<div id=\"a2\" style=\"display: none;\">Of course! DBBlobEditor import JSON files to Access MEMO (CLOB) locally, absolutely safe.<\/div>\n<div><a href=\"#faq\" onclick=\"a3.style.display = 'block';\">Can I import JSON files to Access MEMO (CLOB) on Linux, Mac OS?<\/a><\/div>\n<div id=\"a3\" style=\"display: none;\">Yes, you can. DBBlobEditor has Linux, Mac OS, and Windows version.<\/div>\n<div><a href=\"#faq\" onclick=\"a4.style.display = 'block';\">Can I import JSON files to Access MEMO (CLOB) in command line?<\/a><\/div>\n<div id=\"a4\" style=\"display: none;\">Yes, you can. DBBlobEditor can running in command line, on Linux, Mac OS, and Windows.<\/div>\n<hr style=\"clear: both;\" \/>\n<p><a href=\"https:\/\/www.withdata.com\/dbblobeditor\/\">More about DBBlobEditor<\/a> &#8211; <a href=\"https:\/\/www.withdata.com\/dbblobeditor\/\">JSON to Access MEMO (CLOB) importer<\/a><\/p>\n<div id=\"download-bottom\" style=\"clear: both;\">\n<p>Download DBBlobEditor<a href=\"#download-bottom\" onclick=\"dbv.style.display = 'block';\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/btn_download_green.png\" alt=\"Download DBBlobEditor\" width=\"165\" height=\"50\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/><\/a> <span id=\"dbv\" style=\"display: none;\"><br \/>\n<a href=\"\/download.php?app=DBBlobEditor&#038;ver=win64\">Windows 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBBlobEditor&#038;ver=win32\">Windows 32 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBBlobEditor&#038;ver=deb\">Linux .deb (For Debian, Ubuntu) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBBlobEditor&#038;ver=rpm\">Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBBlobEditor&#038;ver=pkg\">MacOS 64 bit<\/a><br \/>\n<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Want to batch import JSON documents into Access MEMO (CLOB) or OLE Object (BLOB) column? Using DBBlobEditor, you can import bulk json files into Access MEMO (CLOB) or OLE Object (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 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[177],"tags":[7,4201,100,4198,4199,1418,4449,4200],"class_list":["post-10152","post","type-post","status-publish","format-standard","hentry","category-dbblobeditor","tag-access","tag-access-import-memo","tag-clob","tag-import-memo","tag-insert-memo","tag-json","tag-json-to-memo","tag-update-memo"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/10152","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=10152"}],"version-history":[{"count":2,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/10152\/revisions"}],"predecessor-version":[{"id":27350,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/10152\/revisions\/27350"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=10152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=10152"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=10152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}