{"id":3789,"date":"2025-06-09T03:58:11","date_gmt":"2025-06-09T03:58:11","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=3789"},"modified":"2026-07-06T03:17:35","modified_gmt":"2026-07-06T03:17:35","slug":"import-data-into-access-from-mongodb-exported-json-file","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/jsontoaccess\/import-data-into-access-from-mongodb-exported-json-file.html","title":{"rendered":"Import data into Access from MongoDB exported JSON"},"content":{"rendered":"<p>Want to import data into  <a href=\"https:\/\/products.office.com\/access\">Access<\/a>  from mongodb exported <a href=\"https:\/\/www.json.org\/\">JSON<\/a> file?<\/p>\n<p>Try Withdata <a href=\"https:\/\/www.withdata.com\/file-to-db\/\">FileToDB<\/a>, a desktop JSON to Access converter for Windows, MacOS, and Linux, Import JSON to Access, Easy and Fast.<\/p>\n<p><a href=\"#download-top\" onclick=\"dtv.style.display = 'block';\">Download FileToDB<\/a>  <a href=\"#download-top\" onclick=\"dtv.style.display = 'block';\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/download_3.jpg\" alt=\"Download FileToDB\" width=\"80\" height=\"22\" style=\"max-width:100%;height:auto;\" \/><\/a> <span id=\"dtv\" style=\"display: none;\"><br \/>\n<a href=\"\/download.php?app=FileToDB&#038;ver=win64\">Windows 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=FileToDB&#038;ver=win32\">Windows 32 bit<\/a><br \/>\n<a href=\"\/download.php?app=FileToDB&#038;ver=deb\">Linux .deb (For Debian, Ubuntu) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=FileToDB&#038;ver=rpm\">Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=FileToDB&#038;ver=pkg\">MacOS 64 bit<\/a><br \/>\n<\/span><\/p>\n<h2>Import data into Access from MongoDB exported JSON file<\/h2>\n<p> Choose Access and logon.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/logon\/choose_access_logon.png\" alt=\"convert MONGODB_JSON file to Access table - Choose Access and logon\" width=\"430\" height=\"443\" style=\"max-width:100%;height:auto;display:block;\" \/><\/p>\n<p> Click &#8220;Wizard &#8211; 1 File To 1 Table&#8221; at task dialog.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/file-to-db\/task-window.png\" alt=\"convert MONGODB_JSON file to Access table - task window\" width=\"722\" height=\"399\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p> Select the &#8220;JSON&#8221; file type.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/file-to-db\/select-file-type-json.png\" ALT=\"Import file data to database table - select file type\" width=\"547\" height=\"236\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>then show the wizard.<\/p>\n<h3>1. Open a MongoDB exported JSON file.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/jsontodb\/wizard-import-json-source-mongo.png\" alt=\"Convert MongoDB exported JSON data to Access table - Open JSON\" width=\"568\" height=\"408\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<h3>2. Select a table and config fields.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/jsontodb\/wizard-import-dest-table-no-schema-mongo.png\" alt=\"Load MongoDB exported JSON data to Access table - select table\" width=\"568\" height=\"408\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<h3>3. Preview data.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/jsontodb\/wizard-import-preview-mongo-access.png\" alt=\"Insert MongoDB exported JSON data to Access table - preview\" width=\"568\" height=\"408\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<h3>4. Import MongoDB exported JSON to Access.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/jsontodb\/wizard-import-json-convert-mongo.png\" alt=\"Import MongoDB exported JSON data to Access table - import\" width=\"568\" height=\"408\" 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<ol>\n<li><a href=\"https:\/\/withdata.com\/file-to-db\/cmd.html\" target=\"_blank\">Save session and create .bat (Windows) or .sh (Linux\/macOS) file for &#8220;JSON to Access&#8221; conversion.<\/a><\/li>\n<li><a href=\"https:\/\/withdata.com\/dbtodb\/schedule-task.html\" target=\"_blank\">Set scheduled task for &#8220;JSON to Access&#8221; conversion.<\/a><\/li>\n<\/ol>\n<hr style=\"clear: both;\" \/>\n<p><a href=\"https:\/\/www.withdata.com\/file-to-db\/\">More about FileToDB<\/a> &#8211; <a href=\"https:\/\/www.withdata.com\/blog\/tag\/access-import-json\">JSON to Access converter<\/a><\/p>\n<div id=\"download-bottom\" style=\"clear: both;\">\n<p>Download FileToDB<a href=\"#download-bottom\" onclick=\"dbv.style.display = 'block';\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/btn_download_green.png\" alt=\"Download FileToDB\" 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=FileToDB&#038;ver=win64\">Windows 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=FileToDB&#038;ver=win32\">Windows 32 bit<\/a><br \/>\n<a href=\"\/download.php?app=FileToDB&#038;ver=deb\">Linux .deb (For Debian, Ubuntu) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=FileToDB&#038;ver=rpm\">Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=FileToDB&#038;ver=pkg\">MacOS 64 bit<\/a><br \/>\n<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Want to import data into Access from mongodb exported JSON file? Try Withdata FileToDB, a desktop JSON to Access converter for Windows, MacOS, and Linux, Import JSON to Access, Easy and Fast. Download FileToDB Windows 64 bit Windows 32 bit Linux .deb (For Debian, Ubuntu) 64 bit Linux .rpm (For Red Hat, Fedora, SUSE) 64 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1417],"tags":[7,13292,1418],"class_list":["post-3789","post","type-post","status-publish","format-standard","hentry","category-jsontoaccess","tag-access","tag-import-mongodb-json","tag-json"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3789","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=3789"}],"version-history":[{"count":13,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3789\/revisions"}],"predecessor-version":[{"id":32662,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3789\/revisions\/32662"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=3789"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=3789"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=3789"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}