{"id":3834,"date":"2025-08-29T05:32:31","date_gmt":"2025-08-29T05:32:31","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=3834"},"modified":"2026-07-25T05:11:10","modified_gmt":"2026-07-25T05:11:10","slug":"copy-access-tables","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/accesscopier\/copy-access-tables.html","title":{"rendered":"Copy Access tables between databases"},"content":{"rendered":"<p>Want to clone  <a href=\"https:\/\/products.office.com\/access\">Access<\/a>  tables, or copy data in  <a href=\"https:\/\/products.office.com\/access\">Access<\/a>  tables from one database to another?<\/p>\n<p>Try Withdata <a href=\"https:\/\/www.withdata.com\/db-copier\/\">DB Copier<\/a>, a desktop Access data transfer for Windows, MacOS, and Linux, Clone Access tables, Copy data in Access tables between databases, East and Fast.<\/p>\n<ul>\n<li>Can run in <span id=\"gui\">GUI<\/span> mode, <a href=\"#copy\">Step by Step<\/a>, just a few mouse clicks.<\/li>\n<li>Can run in <a href=\"\/tools\/db-to-db\/copy-between-access-cmd\" target=\"_blank\">Command line<\/a>, for <a href=\"\/tools\/db-to-db\/copy-between-access-task\" target=\"_blank\">Scheduled Tasks<\/a> and Streams.<\/li>\n<li>Support <a href=\"\/tools\/db-to-db\/copy-between-access-windows\" target=\"_blank\">Windows<\/a>, <a href=\"\/tools\/db-to-db\/copy-between-access-linux\" target=\"_blank\">Linux<\/a>, and <a href=\"\/tools\/db-to-db\/copy-between-access-macos\" target=\"_blank\">macOS<\/a>.<\/li>\n<\/ul>\n<p><a href=\"#download-top\" onclick=\"dtv.style.display = 'block';\">Download Withdata DBCopier<\/a>  <a href=\"#download-top\" onclick=\"dtv.style.display = 'block';\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/download_3.jpg\" alt=\"Download DBCopier\" width=\"80\" height=\"22\" style=\"max-width:100%;height:auto;\" \/><\/a> <span id=\"dtv\" style=\"display: none;\"><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=win64\">Windows 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=win32\">Windows 32 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=deb\">Linux .deb (For Debian, Ubuntu) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=rpm\">Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=pkg\">MacOS 64 bit<\/a><br \/>\n<\/span><\/p>\n<h2 id=\"copy\">Copy Access tables between databases<\/h2>\n<p><a href=\"#login\">Login to source and target Access<\/a> -> <a href=\"#source\">Select Access tables to copy<\/a> -> <a href=\"#do\">Copy data between Access databases<\/a><\/p>\n<p id=\"login\"> Choose source\/target Access database and logon.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/logon\/choose_access_logon.png\" alt=\"copy data between Access  databases - Choose Access and logon\" width=\"430\" height=\"443\" style=\"max-width:100%;height:auto;display:block;\" \/><\/p>\n<p>Click &#8220;Convert All Tables&#8221; at task dialog.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_a_1.png\" alt=\"Batch copy data from one Access tables to another Access - Task Window\" width=\"636\" height=\"479\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>then show the wizard.<\/p>\n<h3 id=\"source\">1. Select source Access tables.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_batch_source_no-schema.png\" alt=\"Batch copy tables data from one Access to another - select tables\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<h3>2. List target Access tables.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_batch_target_no-schema.png\" alt=\"Batch convert data from one Access tables to another Access - select destination schema\" width=\"724\" height=\"573\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<h3>3. Select target Access tables to copy data.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_batch_map.png\" alt=\"Batch import data from one Access tables to another Access - select tables\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<h3 id=\"do\">4. Copy Access tables between databases.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_batch_convert.png\" alt=\"Batch transfer data from one Access tables to another Access - import\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<hr style=\"clear: both;\" \/>\n<p>More about <a href=\"\/tools\/db-to-db\/copy-between-access\">Access Copier<\/a><\/p>\n<div id=\"download-bottom\" style=\"clear: both;\">\n<p>Download Withdata DBCopier<a href=\"#download-bottom\" onclick=\"dbv.style.display = 'block';\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/btn_download_green.png\" alt=\"Download DBCopier\" 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=DBCopier&#038;ver=win64\">Windows 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=win32\">Windows 32 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=deb\">Linux .deb (For Debian, Ubuntu) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=rpm\">Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=pkg\">MacOS 64 bit<\/a><br \/>\n<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Want to clone Access tables, or copy data in Access tables from one database to another? Try Withdata DB Copier, a desktop Access data transfer for Windows, MacOS, and Linux, Clone Access tables, Copy data in Access tables between databases, East and Fast. Can run in GUI mode, Step by Step, just a few mouse [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1454],"tags":[7,13305],"class_list":["post-3834","post","type-post","status-publish","format-standard","hentry","category-accesscopier","tag-access","tag-batch-copy"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3834","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=3834"}],"version-history":[{"count":19,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3834\/revisions"}],"predecessor-version":[{"id":45117,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3834\/revisions\/45117"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=3834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=3834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=3834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}